SSIS; create DTSX Package via C# code

#1

Hello,

I am trying to generate a DTSX via C# Source that just copies one table
column into another table. Starting with a already existing package that
does that my analysis failed finding all information within the package like
sourcetable or destination table. Where I can retrieve all necessary
information out of the Microsoft.SqlServer.Dts.Runtime.Package object?

regards
Mark

#2

Mark,

In Books Online there are a large amount of code samples around this. You
can find some of them here.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9mref/html/T_Microsoft_SqlServer_Dts_Pipeline_Wrapper_MainPip e.htm

and

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/0ca03712-a82e-4aa7-949b-f869a8936ddf.htm

--

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

"Mark" <Scollop027 (AT) gmx (DOT) net> wrote

Quote:

Hello,

I am trying to generate a DTSX via C# Source that just copies one table
column into another table. Starting with a already existing package that
does that my analysis failed finding all information within the package
like
sourcetable or destination table. Where I can retrieve all necessary
information out of the Microsoft.SqlServer.Dts.Runtime.Package object?

regards
Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS; create DTSX Package via C# code

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SSIS; create DTSX Package via C# code - 08-16-2006 , 02:32 PM

Re: SSIS; create DTSX Package via C# code - 08-16-2006 , 04:08 PM