SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Run 2012 SSIS package on SQL Server 2005


Run 2012 SSIS package on SQL Server 2005

Author
Message
gwgeller
gwgeller
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 138
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
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)

Group: General Forum Members
Points: 67835 Visits: 18570
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

gwgeller
gwgeller
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 138
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.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)

Group: Administrators
Points: 149011 Visits: 19446
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
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)

Group: General Forum Members
Points: 67835 Visits: 18570
Steve Jones - SSC Editor (1/2/2013)
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.


Yup, I'd just get the standard edition to run it. But a 2012 license is required.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw

gwgeller
gwgeller
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 138
ok, thank you both for your input.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search