25112
asked on
where to deploy packages inside SSIS? (2012)
when you deploy a package in SSIS, what is the best standards as to where to put the package?
There is 'Running Packages' and 'Stored Packages' folder. Then under Stored, there is 'File System' and MSDB.. Under MSDB, there is Maintenance plans. Where exactly is it is recommended to put the package and then later call it from SQL Job step.
thanks.
There is 'Running Packages' and 'Stored Packages' folder. Then under Stored, there is 'File System' and MSDB.. Under MSDB, there is Maintenance plans. Where exactly is it is recommended to put the package and then later call it from SQL Job step.
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK-appreciate that.
otherwise package store on filesystem is good option.