Run 2012 SSIS package on SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Run 2012 SSIS package on SQL Server 2005

Run 2012 SSIS package on SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

gwgeller

Posted Wednesday, January 02, 2013 9:55 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 06, 2013 4:10 PM
Points: 18, Visits: 136

Hello all,
We work alot with mysql and will only be doing more, although sql server will remain prevalent. We utilize SSIS, and even DTS still, to move our data around. Problem is working with mysql in SSIS 2005 is a pain and now I've run into a situation where it might take a bunch of hacks. So I read that 2012 will take care of a few issues I'm having. Mainly actual ODBC sources and destinations, and no 4000 character expression limit.

We have several sql server 2005 instances running already. I see that a sql server development license is really cheap. So I have two questions. If I were to purchase a 2012 sql server developer license...

1. Would the license allow me to develop 2012 version packages and deploy them to a 2005 instance?
2. Would a 2012 package run using 2005 sql server? I plan on running the packages from the file system using sql agent.

Thanks,
GG

Post #1401936

SQLRNNR

Posted Wednesday, January 02, 2013 10:09 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 12:32 AM
Points: 18,855, Visits: 12,439

You cannot deploy a 2012 package to SQL Server 2005.

However, you can use SQL Server 2005 in your connection manager. But the package must be run from SQL 2012.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1401947

gwgeller

Posted Wednesday, January 02, 2013 10:18 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 06, 2013 4:10 PM
Points: 18, Visits: 136

Thank you for the reply. Basically we need the new features in SSIS, not Sql server. So if there is a way to avoid having to buy a full version of Sql server 2012 just to utilize SSIS 2012 please let me know.

Post #1401951

Steve Jones - SSC Editor

Posted Wednesday, January 02, 2013 10:31 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:19 PM
Points: 31,526, Visits: 13,863

There isn't a way to do this. While SSIS is a separate part of SQL Server and can be deployed without the database engine, you cannot use the redistributable parts of SSIS, AFAIK, without having a SQL Server 2012 license.

You could purchase an SE license, as few cores/CALs as needed to run things.

Follow me on Twitter: @way0utwest