Hi to all,

is there a possibiliy to use SSIS-Packages within an Orchestration??
We have a lot of SSIS-Packages and, because of the great number of packages,
migrating is not an option. On the other hand, not using these packages woul
d
slow down our application integration project.

Any hints are welcome. )

Thanks in advance
Hendrik

[ Post a follow-up to this message ]

"theonlyhenni" wrote:

> Hi to all,
>
> is there a possibiliy to use SSIS-Packages within an Orchestration??
> We have a lot of SSIS-Packages and, because of the great number of package
s,
> migrating is not an option. On the other hand, not using these packages wo
uld
> slow down our application integration project.
>
> Any hints are welcome. )
>
> Thanks in advance
> Hendrik

[ Post a follow-up to this message ]

Sorry for the empty post right before this one.

This is an excellent question.  I would recommend that you study the article
called
"Execute Sql Server 2005 Integration Services package from c#"
http://www.codeproject.com/useritem...SFromCSharp.asp
(I have seen similar techniques for sql server 2000 dts, so I know that it
is possible)

My idea is for you to use the Expression Editor shape to call your custom
assembly.  The custom assembly does the work of calling the DTS or SSIS
packages.  The downside to this approach is that you won't see the "send"
shapes explicitly in your orchestration, so I would recommend naming your
expression shapes with meaningful names (since you may have a lot of them!).

Hope this helps.

"theonlyhenni" wrote:

> Hi to all,
>
> is there a possibiliy to use SSIS-Packages within an Orchestration??
> We have a lot of SSIS-Packages and, because of the great number of package
s,
> migrating is not an option. On the other hand, not using these packages wo
uld
> slow down our application integration project.
>
> Any hints are welcome. )
>
> Thanks in advance
> Hendrik

[ Post a follow-up to this message ]

thanks for your answer.  now i call the packages by c#-code 

"WMIBookie" wrote:
[vbcol=seagreen]
> Sorry for the empty post right before this one.
>
> This is an excellent question.  I would recommend that you study the artic
le
> called
> "Execute Sql Server 2005 Integration Services package from c#"
> http://www.codeproject.com/useritem...SFromCSharp.asp
> (I have seen similar techniques for sql server 2000 dts, so I know that it
> is possible)
>
> My idea is for you to use the Expression Editor shape to call your custom
> assembly.  The custom assembly does the work of calling the DTS or SSIS
> packages.  The downside to this approach is that you won't see the "send"
> shapes explicitly in your orchestration, so I would recommend naming your
> expression shapes with meaningful names (since you may have a lot of them!
).
>
> Hope this helps.
>
> "theonlyhenni" wrote:
> 

[ Post a follow-up to this message ]