|
Home > Archive > BizTalk Server Orchestration > June 2006 > Can I use SSIS-Packages within BizTalk 2006 Orchestrations??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can I use SSIS-Packages within BizTalk 2006 Orchestrations??
|
|
| theonlyhenni 2006-05-30, 1:14 pm |
| 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 would
slow down our application integration project.
Any hints are welcome.  )
Thanks in advance
Hendrik
| |
| WMIBookie 2006-05-30, 1:14 pm |
|
"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 packages,
> migrating is not an option. On the other hand, not using these packages would
> slow down our application integration project.
>
> Any hints are welcome. )
>
> Thanks in advance
> Hendrik
| |
| WMIBookie 2006-05-30, 1:14 pm |
| 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 packages,
> migrating is not an option. On the other hand, not using these packages would
> slow down our application integration project.
>
> Any hints are welcome. )
>
> Thanks in advance
> Hendrik
| |
| theonlyhenni 2006-06-09, 1:18 pm |
| 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 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:
>
|
|
|
|
|