I have packages created in Visual Studio 2005 and executing in SQL Server 2005. But I wonder if i can execute the package in SQL Server 2008? Thanks Laila

Nothing should stop you from running packages created in 2005 on a 2008 server. However you run a risk of getting caught in some errors because of differences between the two versions and the log might not help you in narrowing on the error. The best approach would be to upgrade your package to 2008 (you do not need visual studio 2008 for the conversion if thats your constratint. Check this for the various upgrade options)http://btsbee.wordpress.com/

Hi, Yes you can execute the package by using dtexec utility.For more details please follow the below link: http://msdn.microsoft.com/en-us/library/ms162810%28v=sql.105%29.aspx*Regards* *Samay Shrivastava* *Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*

Hello, I agree with both the guys. You may be required to convert the package using VS 2008. If you encounter more issues then let us know.