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
- 5352 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
How can windows applications connect to sql servers via odbc?
What is data source view or dsv? : sql server analysis services, ssas
What are sql server functions?
Equi join and non equi join is possible with sql server?
How can I create a new template for import ? : sql server management studio
What is a dbms wizard?
What are the methods used to protect against sql injection attack?
What is index in an assignment?
List out the differences between global and local temp tables in sql server?
What are the different Topologies in which Replication can be configured?
What is sql server management studio? : sql server management studio
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is the purpose of the master database?
How to install sql server 2005 express edition?
List some advantages and disadvantages of stored procedure?
