Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Unable to import SISS packages

Author  Topic 

nmcl
Starting Member

1 Post

Posted - 2009-07-06 : 11:00:16
Hi

I'm having problems saving SISS packages into the internal master tables on SQL 2005. When trying to do this I get:

Exception details
Save to SQL Server failed.
Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.
(SQL Server Import and Export Wizard)
Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage100 Package, IDTSEvents100 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.DtsWizard.Execute.DoFileSaveStep(Exception& ex)

I've also noticed that when going into the MSDB folder under stored packages in integration services I get a Failed to retrieve Data for this request error, saying Login timed out.

Are the two issues related? Anyone have any ideas?

Many thanks for any help.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-07-12 : 08:32:44
seems like the packages were created in an earlier version of sql server as error suggests. whats the version of sql server you use and was packages created from another version>?
Go to Top of Page
   

- Advertisement -