How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
Answer / guest
You can use the DTS object model to programmatically create,
modify and run DTS packages.
You can do this many ways, but essentially this object model
has objects for anything you can do in DTS.
If you already have the package created and saved as a file,
add a reference to the DTS Library.
Then you can call it like this:
Dim Package As New DTS.Package
Package.LoadFromStorageFile App.Path "\DTSPackage.dts"
Package.Execute
Is This Answer Correct ? | 2 Yes | 0 No |
How data can be copied from one table to another table?
What to perform pattern match with the like operator?
What are the different Topologies in which Replication can be configured?
Which command displays the SQL command in the SQL buffer, and then executes it?
Can we shrink data file in sql server?
What is temporal data type?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is #table in sql server?
What is 3nf normalization form?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
How can a database be repaired?
what is the Enterprise manager(2000) and management studio (2005)?