Currently I have a SSIS 2005 project that transfer SQL 2000 database(data source) to SQL 2005 database (data destination). Now we need to upgrade the data source of SQL 2000 database to SQL 2008. And I want to keep Integration Service at SQL 2005, no touch on SSIS packages and integraiton server. Only data source database needs to upgrade to SQL 2008. What kind of change I may need to make on SSIS 2005 packages? I assume only configuration of database connection string should be changed. Any other issues I may have? Thanks Helen

Hi, You need to change your conenction string to be able to get the data from SQL Server 2008 instead of SQL Server 2000. To do this, open up your SSIS solution, and in connection manager pane locate the connection that is used in your source (in the data flow tasks). There are 2 scenarios now: 1- If your conenction manager is of type ADO.NET, right click on the entry in Connection Managers pane, and select Edit. You will be able to edit it to point to your new server. 2- If your connection manager is OLE DB, then you have no choice but to delete it and re-create. Configure the new OLE DB connection manager to point to the new db and server. Hope this helps.Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Connection string needs to be changed for provider. Might want to check deprecated features SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%Deprecated Features%')http://sqlworkday.blogspot.com/

Thanks Yogesh. About your check deprecated features, do you mean I need to run it on SQL 2008 (the upgreded one)? What's it used for? Does it related to SSIS 2005 packages? Could you please give me some link so I can drill down to the datail? ThanksHelen