August 26, 2008 at 1:29 am
Hi,
I am new to SQL 2005 and just want some advice on SSIS packages.
What is the best practice to implementing them. Should I be keeping them in the MSDB or locally as DTSX files?
Regards,
Brad
August 26, 2008 at 3:22 am
Hello,
If like us, you have multiple environments i.e. Dev, UAT, Production, you might find it easier to handle packages as files.
This way you can be sure to promote the same physical file through each environment after each level of testing is completed. You probably only need to have an environment specific configuration (file).
(If somebody else has some good ideas on how to do this with SSIS Packages in the msdb, could they please post them?)
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply