I have created one project for SSIS and deployed that on sql server 2014. When I am running packages from sql server data tool its running fine and performing all operations, but when I am running from catlog procs [SSISDB].[CATALOG].[Create_execution] its shows run successful but I can't see any data into my staging tables. I have used configuration tables to configure connection and files path. Any idea.
0
votes
Do you have any parameters in your package?
- Tyron78
Yes and I am sending same parameter as sending from data tools
- Chaman Shukla
I faced a similar problem some time ago and the reason was the order of the parameters - this resulted in the package not finding any records. Another possibility might be user privileges: are you executing the procedures with the same user you use in Data Tools?
- Tyron78
Ok so problem was shared folder which was accessible from visual studio but not from sql server. Thank you for your time.
- Chaman Shukla
Glad I could help. Please accept the answer.
- Tyron78
