1

Possible Duplicate:
Is it possible to deploy SSIS 2012 package on SQL Server 2008

currently I have Visual Studio 2010 and SQL Server 2012 on my pc. Now I want to create a SSIS package, which should run on a SQL Server 2008.

If I create it normally, I just get the following error, if I try to load it on the server:

The package failed to load due to error 0xc0010014 "[...]" This occurs when CPackage::LoadFromXML fails.

If I try to open it with BIS 2008, then I get a similar error.

Is there any way to change my dtsx so that it will work on a SQL Server 2008?

Community
  • 1
  • 1
Core_F
  • 3,372
  • 3
  • 30
  • 53
  • 1
    This is why you never create code in a version of the software higher than the one you intend to use. You must create packages in BIDS 2008. You also should NOT be developing against a 2012 database if your production db is 2008. – HLGEM Sep 04 '12 at 16:50

1 Answers1

6

You can't. Packages have changed since 2008 : the XML structure is not the same. Packages created for SQL Server 2012 will only run for that technology. To have a 2008 package, create it using BIDS 2008.

Dominic Goulet
  • 7,983
  • 7
  • 28
  • 56