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.
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.