Well...
Creating a DTS package means alot of issues coming in.... U will have to
keep in track of what type of data is coming in... ost of them beng from a
Text file or Excel File or Access file or from a different DB managment
system like sybase or Oracle of DB2 or even from the same SQL. and u need to
map each tables to the tables in the new DB and also map the fields and
specify if the dataType (if it gonna change)... and a lot more.... Well i
hope DTS offers a wide range of attributes and so u can better use it i
hope.....\\\
keep me posted f any issues...


==============================
S.Ramanujam
Programmer Analyst
Cognizant Technology Solutions (p) Ltd. - CTS
38 & 39 Whites Road,
WCB - Whites Road Circular Building
Royapettah, Chennai - 600014
Ph : +xx xx xxx xxxx Extn 5113 [Off]
     : +xx xx xxx xxxx                 [Res]


-----Original Message-----
From: sswift@i... [mailto:sswift@i...]
Sent: Friday, August 23, 2002 10:33 PM
To: ASPX_Professional
Subject: [aspx_professional] DTS Packages


Does anyone have a good example of how to create a DTS package with C#.

I'm able to create one on the SQL Server and then run from within C#, but 
I'd like to programatically create in my code since things about the 
package will change on a regular basis.

Thanks,
Steve
---

ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442

ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450

These books are a complete reference to the ASP.NET namespaces 
for developers who are already familiar with using ASP.NET. 
There is no trivial introductory material or useless .NET 
hype and the presentation of the namespaces, in an easy-to use 
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes, 
giving you those real-world tips that the documentation doesn't 
offer, and demonstrating complex techniques with simple 
examples.  

---