execute package SSIS-2008 with dtexec 2005

Question

execute package SSIS-2008 with dtexec 2005

msimone

SSCommitted

Points: 1846
More actions
September 8, 2009 at 9:29 am

#137876

I have customers with sqlserver 2005, but i have sqlserver 2008.
I need that a engine 2005 run packages SSIS 2008.
It's possible?
Thanks for all.
September 8, 2009 at 11:37 pm

This was removed by the editor as SPAM
September 8, 2009 at 11:39 pm

This was removed by the editor as SPAM
September 9, 2009 at 12:47 am

This was removed by the editor as SPAM
April 8, 2011 at 2:27 am

This was removed by the editor as SPAM
April 11, 2011 at 9:12 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

I would be surprised if you could run a SSIS 2008 package using SQL 2005 tools. A SSIS package is an XML document that, amongst other things, includes information (near the start of the file) about the version of the XML/SSIS schema that is used to define the package. I don't have a copy of SQL 2008 available to me at present so I can't confirm it, but I expect that the schemas will be different between 2005 and 2008 and this will be what stops you.

keepintouch2b Say Hey Kid Points: 682 More actions · Answer 2

So what is the final answer?

Will SSIS 2008 package run with SQL Server 2005 DTExec?

Yes or No or Maybe Yes.

Regarding maybe Yes, I am referring to simple packages with simple SQL tasks and no CLR in it.

Follow question is:

Will SSIS 2005 package without project without migrating to SSIS 2008 be editable in Visual Studio 2008 BIDS?

Is the recommendation stay with editing SSIS 2005 with VS 2005 BIDS?

Thanks,

Jeff

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

keepintouch2b (4/7/2011)
So what is the final answer?
Will SSIS 2008 package run with SQL Server 2005 DTExec?
Yes or No or Maybe Yes.
Regarding maybe Yes, I am referring to simple packages with simple SQL tasks and no CLR in it.
Follow question is:
Will SSIS 2005 package without project without migrating to SSIS 2008 be editable in Visual Studio 2008 BIDS?
Is the recommendation stay with editing SSIS 2005 with VS 2005 BIDS?

SSIS 2008 will not run on 2005. 2005 does not have forward compatibility.

Opening 2005 packages in BIDS 2008 will upgrade them to 2008, so you'll need a side-by-side install of BIDS 2005 and 2008.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

keepintouch2b Say Hey Kid Points: 682 More actions · Answer 4

Thanks for the info.

With the understanding, that Visual 2008 BIDS will run SSIS 2008 package.

To be more specific, my question is directed at the command run statement in production SQL Server 2005.

So will [b]SQL Server 2005[/b] DTEXEC /F "SSIS_2008_Package.dtsx" run?

Yes, No, Maybe if no CLR code in package?

Thanks,

Jeffrey