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


Please Help Members By Posting Answers For Below Questions

Is it possible to call a stored procedure within a stored procedure?

764


What happens to a trigger with multiple affected rows?

731


Explain the properties of a relational table?

806


What is sql server schema compare? How we can compare two database schemas?

804


how to create a scrollable cursor with the scroll option? : Sql server database administration

825


Mention what are the different types of ssrs reports?

128


Define magic tables in sql server?

795


How to rename databases in ms sql server?

895


What are system databases in ms sql server?

759


How to update muliple row in single query?

846


what are different types of raid configurations? : Sql server database administration

760


Explain “not null constraint” in sql server?

772


What are drillthrough reports?

130


Explain what is analysis service repository?

762


How to get the definition of a view out of the sql server?

751