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 Posted / 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 |
Post New Answer View All Answers
When would you prefer to have a minimum number of indexes?
Why de-normalization required?
Data table as parameter in sql server?
What is implicit mode in sql server?
What are various ways to enhance the ssrs report?
What are the steps to insert a table?
How to encrypt Strored Procedure in SQL SERVER?
What structure can you implement for the database to speed up table reads?
What are the differences between stored procedure and the dynamic sql?
Explain the creation and execution of a user-defined function in the sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is sql view?
what are defaults? : Sql server database administration
Explain the working of sql privileges?
Can we linked SharePoint to a SQL database?