I am in the process of migrating from SQL2005 on Windows Server 2003 SP2 to SQL2008 on Windows Server 2008 Enterprise. I am attempting to use the dtutil command to migrate multiple (100+) existing SSIS packages to the new server. I have attempted to push the jobs from the old server to the new server using this command: dtutil /sql <packagename> /DestServer <servername.fqdn> /copy SQL;<packagename> Which returns: Error (0xC0014014) while checking for the existence of package <packagename> on SQL Server. Could not save package <packagename> because of error 0x80040E14. Description: Could not find stored procedure 'sp_dts_putpackage'. Source: Microsoft SQL Native Client I then tried to pull the packages from the new server with both the 32-bit and 64-bit dtutil using: dtutil /sql <packagename> /SourceServer <servername> /copy SQL;<packagename> Which returns: Error (0x80040E14) getting package <packagename> from SQL Server. Description: Could not find stored procedure 'sp_ssis_getpackage'. Source: Microsoft SQL Server Native Client 10.0 Both servers are using Windows Authentication only and I am serveradmin on both systems.

Hello, You need to upgrade your packages, open a new solution of SSIS 2008 , then right mouse on SSIS Packages and then go to Upgrade All packages.. then select the pacakges and they will be upgraded to SSIS 2008 and you can run them on SQL SERVER 2008 then. Important Note: Please make a copy of your packages before you do upgrades, as after upgrading packages you will not be able to run those package on SQL 2005. Helpful links http://www.sql-server-performance.com/articles/dba/upgarde_2005_packages_2008_i_p1.aspx http://msdn.microsoft.com/en-us/library/cc280547.aspx Thanks

Hi Ronny, You can check the following post: http://social.msdn.microsoft.com/Forums/en/sqltools/thread/8e2c530a-3e45-46bd-926e-733827c843b6 Also, do you have "Microsoft SQL Server 2005 Backward Compatibility Components" on the new server? Regards, Akim

http://www.sql-server-performance.com/articles/dba/upgarde_2005_packages_2008_i_p1.aspx This link pointed me to the SSISUPGRADE wizard (that is not particularly well documented,) which solved all of my problems. The DTUTIL utility was apparently a red herring for this particular process. THANKS!