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 to get the salary in descending order with out using the keyword desc in sql
what is bit datatype? : Sql server database administration
What is the difference between Normalization and De-normalization?
When would you use sql joins?
Difference between group by clause and having clause in SQL?
What do you mean by data manipulation language?
Difference between 2NF &3NF ?
In clustered and non clustered indexes which one is faster while executing a query ?
How to concatenate two strings in SQL Server.
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What information is maintained within the msdb database?
How adventureworkslt tables are related?
Oracle (3253)
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)