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
Is it possible to call a stored procedure within a stored procedure?
What happens to a trigger with multiple affected rows?
Explain the properties of a relational table?
What is sql server schema compare? How we can compare two database schemas?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Mention what are the different types of ssrs reports?
Define magic tables in sql server?
How to rename databases in ms sql server?
What are system databases in ms sql server?
How to update muliple row in single query?
what are different types of raid configurations? : Sql server database administration
Explain “not null constraint” in sql server?
What are drillthrough reports?
Explain what is analysis service repository?
How to get the definition of a view out of the sql server?