January 3, 2015 at 3:09 am
Hi All,
I have deployed a package using deployment utility by manifest file at SQLServer level (msdb), and scheduled it in a job.
Deployment utility consist three files.
1) dtsx package
2) Config file (Already configured as per server settings)
3) manifest file
We know after deployment at sql level the config file by default is place at location
"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\[PackageName]\"
Question-
Do we need to map configuration file in "Configuration tab" of job while creating a Step explicitly,place at location mentioned above?
Job is configured as "Sql Server Integration Service" type.
I believe that the package schedule in the step picks automatically the config file placed at default location, mentioned above.
Can anyone please suggest for the same?
January 7, 2015 at 11:29 pm
Anyone to Help me out with this confusion, if there's some missing info please let me know
January 8, 2015 at 3:17 am
What is shown on the 'Command Line' tab? If there is a /CONFIG switch in there with the path and name of a config file, then that is the config file being used by the job.
Regards
Lempster
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply