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 |
what are the main differences between ms access and sqlserver
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"
How to update a field in SQL after ALTERING a row?
Where are SQL server users names and passwords are stored in sql server?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Explain aggregate functions?
Explain the truncate command? : SQL Server Architecture
What is the cartesian product of the table?
If the job running very slow what is the action you do
What is RAID and what are different types of RAID configurations?
What is BLOCK statements in SQL?
Can you explain the role of each service?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)