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 different types of views?
How to convert character strings into numeric values?
Can you have a nested transaction?
What triggers long term care?
Explain what are the authentication modes in sql server?
What is the significance of master, tempdb and model databases?
when would you go for denormalization? : Sql server database administration
Can we use custom code in ssrs?
How to insert new line characters into strings?
What types of integrity are enforced by a foreign-key constraint
What is abstracting periodical?
What is the difference between clustered index and primary key?