CODEWITHSUNDEEP
ssis
Chaman Shukla
Chaman Shukla

Reputation: 169

SSIS package not running from SQL server catalog

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.

Upvotes: 0

Views: 1222

Answers (1)

Tyron78
Tyron78

Reputation: 4187

PLease check the user privileges (file system, etc.) - if you call the procedures with another user than you execute the package from within Data Tools, this might be the reason.

Upvotes: 1

Related Questions