471,603 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,603 software developers and data experts.

How to use DTS package in C#

Hi all,
I'm a rookie and would like to know how do I use the DTS
package in my C# code.
I actually want to input a pipe-delimited text file and convert it into
SQL tables and also validate the values in the data field (eg. the
state data field should not have more than 2 chars. .. etc).

Please help!

thanx

Feb 13 '06 #1
2 2449
Hello juventusaurabh,

What's the DTS ?

j> I'm a rookie and would like to know how do I use the DTS
j> package in my C# code.
j> I actually want to input a pipe-delimited text file and convert it
j> into SQL tables and also validate the values in the data field (eg.
j> the state data field should not have more than 2 chars. .. etc).
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Feb 13 '06 #2
Hi,

"juventusaurabh" <sa************@gmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hi all,
I'm a rookie and would like to know how do I use the DTS
package in my C# code.
I actually want to input a pipe-delimited text file and convert it into
SQL tables and also validate the values in the data field (eg. the
state data field should not have more than 2 chars. .. etc).


This is what I do, I create the DTS in the enterprise manager, when I'm sure
it does work as expected ( data convertion, etc) I save it in disk, this
create a DTS file, later on I use the code below to set the correct data
connections .
You can set a number of other parameters, take a look at the doc, the code
below will give you an idea of how to start
void RunPackage( string packSource, string packName, string dataSource)
{
try
{
Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;

// if you need to load from file
package.LoadFromStorageFile(
packSource,
null,
null,
null,
packName,
ref pVarPersistStgOfHost);

package._Package_Connections.Item(1).DataSource = dataSource;
package.Execute();
package.UnInitialize();

// force Release() on COM object
//
System.Runtime.InteropServices.Marshal.ReleaseComO bject(package);
package = null;
}
catch(System.Runtime.InteropServices.COMException e)
{
Console.WriteLine("COMException {0}", e.ErrorCode.ToString() );
Console.WriteLine("{0}", e.Message);
Console.WriteLine("{0}", e.Source);
Console.WriteLine("Stack dump\n{0}\n", e.StackTrace);
Console.ReadLine();
}
catch(System.Exception e)
{
Console.WriteLine("Exception");
Console.WriteLine("{0}", e.Message);
Console.WriteLine("{0}", e.Source);
Console.WriteLine("Stack dump\n{0}\n", e.StackTrace);

Console.ReadLine();
}
}

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
Feb 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Petterson Mikael | last post: by
10 posts views Thread by datapro01 | last post: by
6 posts views Thread by Page Horton | last post: by
3 posts views Thread by shorti | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
reply views Thread by Steven Samuel Cole | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by MichaelMortimer | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.