Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

run sql 2008 ssis package in sql 2012 machine Expand / Collapse
Author
Message
Posted Monday, May 12, 2014 3:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 11:02 AM
Points: 151, Visits: 194
Hello,
I have created a ssis package in sql server 2008 and use a job to execute it pointing to databaseA. works fine.
Then, I place that package into a sql server 2012 machine and use a job to execute it in the same database, databaseA.
The error I get is something like:
can not use the old version in the new version machine.

Is this really the case or am I doing something wrong please?
Post #1569735
Posted Monday, May 12, 2014 4:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
It really is the case. If you want to use it in SQL Server 2012 environment, you need to upgrade the package first.
Normally SSIS does this for you, so I am interested in the actual error.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1569744
Posted Monday, May 12, 2014 5:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 11:02 AM
Points: 151, Visits: 194
Koen Verbeeck (5/12/2014)
It really is the case. If you want to use it in SQL Server 2012 environment, you need to upgrade the package first.
Normally SSIS does this for you, so I am interested in the actual error.

Hello,
I have included the error as attachment here.
Note that the ssis package is saved and run in sql 2012
Any suggestions please?
Thanks


  Post Attachments 
error.docx (7 views, 23.61 KB)
Post #1569782
Posted Monday, May 12, 2014 5:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
When do you get that error?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1569786
Posted Monday, May 12, 2014 5:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 11:02 AM
Points: 151, Visits: 194
Koen Verbeeck (5/12/2014)
When do you get that error?

My apologies. I think I mis-guided you.
Let me explain again:
1- built ssis package in sql 2012. using a job to execute it. works good.
2- now in sql 2008, would like to do the same thing i.e. use a job to execute that package.
Question:
Is this possible? i.e. going from 2012 to 2008?
Thanks
Post #1569789
Posted Monday, May 12, 2014 5:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
No, you cannot downgrade an SSIS package.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1569791
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse