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
- 5444 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
Define the one-to-one relationship while designing tables.
How do I install sql server?
What is the security model used in sql server 2005?
Write a SQL query in order to merge two different columns into single column?
Explain the dbcc pintable command when would you use it?
Why should you use or avoid select * statements?
What are the two modes of authentication in sql server?
How to get the definition of a user defined function back?
What are drillthrough reports?
How to manipulate data from one table to another table ?
How to find table changes in sql server?
What are different types of roles provided by ssrs?
Explain in details security in SQL azure?
What part does database design plays a role in performance of an sql server-based application?
What do you understand by triggers?
