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
Difference between drill down and drill through report.
Explain what is dbcc?
Can you explain what are various ways to enhance the ssrs report?
How can I check that whether automatic statistic update is enabled or not?
What are the commands used in DCL?
Why use stored procedures in sql server?
Why are you getting errors when creating a new odbc dsn?
How to deploy the Report?
What are group functions in query statements in ms sql server?
Where the sql logs gets stored? : sql server database administration
What are the restrictions applicable while creating views? : SQL Server Architecture
What are the types of user defined functions in sql server?
How much is a sql server license?
Write a SQL queries on Self Join and Inner Join.
how can u get last observation in an unknown dataset ?