July 27, 2012 at 5:01 am
i just want to know, what changes has to make when i want to run a package in 2008 environment which i designed in 2005 environment, package having some execute sql task.
please help
July 27, 2012 at 5:33 am
You just need to upgrade the package to the 2008 SSIS version (it will change a version number in the XML behind the .dtsx and upgrade the native providers) Since you are using only Execute SQL Tasks, the upgrade will be quite painless. If you have configurations setting the connectionstrings to SQL Server, make sure they use the native provider of SQL 2008.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 27, 2012 at 6:07 am
BTW, it is not entirely painless. If you have any OLE DB Destinations in a Data Flow Task, you will get a number of SSIS warnings about the FastLoadMaxInsertCommitSize. 2005 saved it as a 0 value, but 2008 wants an actual value.
The package will run fine in this situation. You can ignore those warnings mostly without any issues. But if warnings annoy you as much as they annoy me, feel free to alter that property value to 2147483647. Which will make the warnings go away.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply