September 26, 2015 at 2:19 pm
Hi All,
I want to understand how the SSIS package and the dtsconfig file connectivity works.
I have the below structure:
SSIS packages are on Server A. Packages have dtsconfig files with path C:\Pack\abc.dtsconfig , it exists on Server A.
These are executed via .net code from Server B.
My Question:
When SSIS is called, where is it being executed , Server A or Server B ?.
Where should be the dtsconfig files be placed , Server A or Server B?.
Because currently my Packages are ignoring the dtsconfig files, when I hardcode the values in the package, it works.
September 27, 2015 at 12:37 am
No views anyone?
September 28, 2015 at 8:36 am
I keep my config file on the same server as the packages run on though I store those packages in msdb.
The account that is defined in the sql agent jobstep to run the package must have permissions to access the config file directory.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply