April 5, 2010 at 7:45 am
Hi Guys
I have several SSIS packages which have been deployed through the MSDB.
I'm concern in regards to my future SSIS deployment. If I create a new SSIS packages how could I deploy my new SSIS package without deploying all of my previous SSIS packages that have been deployed already to my SQL Server?
Or what if I create a new SSIS packages and modified a previous SSIS packages that was deployed already, does SQL 2005 override my old SSIS package? Also what if the SSIS package is running when I deploy it does SQL wait until the SSIS package complete before it deploys it?
April 5, 2010 at 5:22 pm
Unless these packages are interdependent, then each package only overwrites it's respective package in MSDB.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply