May 12, 2014 at 3:40 am
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?
May 12, 2014 at 4:11 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 12, 2014 at 5:36 am
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
May 12, 2014 at 5:42 am
When do you get that error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 12, 2014 at 5:50 am
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
May 12, 2014 at 5:52 am
No, you cannot downgrade an SSIS package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply