Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 5335 Views
- GE, I also Faced
- E-Mail Answers
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
What is the security principal at the database level that represents your session?
What is the difference between row_number and dense_rank?
How to list all user defined functions in the current database?
What does this statement do @@rowcount?
Explain Reporting Life Cycle?
How do I partition a table in sql server?
How to create dbo table in sql server?
Tell me the phases a transaction has to undergo?
How do I find the size of a sql server database?
What is the synonym of join?
In which format does an image save in SQL Server database ?
How to define output parameters in stored procedures?
What is sleeping status in sql server?
Tell me what is fill factor?
What is merge statement?
