Problem saving SSIS Package to SQL Server
Posted on 2010-08-13
I am using the import wizard to try to save a package to sql server. I get the error 'The attempted operation is not supported with this database version' in the save step. I did some research and found out that the problem lies in that I have a instance name attached to the server name. It said to change the configuration of the file MsDtsSrvr.ini.xml. I did as it said changing the <ServerName> to ServerName\InstanceName. I restarted SSIS in the configuration manager and tried to save again. No luck. Anybody have any ideas? Using 2008 SQL Server Managment Studio and server is SQL Server 2005.