Wednesday, March 7, 2012

How to launch them?

Hi everyone,

Primary platform is Framework 2.0

Our vb application throws .dtsx by means of the usual methods.

When I want to run packages allocated in my Windows folder I use LoadPackage; when I want to run packages allocated in my MSDB I use LoadFromSqlServer and at the end of the day when

I want to run packages allocated in my File System SSIS folder I use LoadFromDtsServer.

Drawbacks come here according a "new sort of SSIS packages". I'm talking about those packages which are imported from Sql2k from

Database Engine->Management->Legacy->Data Transformation Services.

How do I launch this kind of SSIS packages?

I'm totally stuck with this. Or maybe the problem is easier: the ones aren't ssis but dts?

Thanks in advance for your input,

If you try to execute DTS 2000 packages then you need to use DTS 2000 object model to load them or to create a SSIS package that contains a Execute DTS 2000 Package task.

Hope this helps,
Ovidiu Burlacu

|||

so you're talking about that they really are dts no ssis. ok

No comments:

Post a Comment