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
- 4912 Views
- GE, I also Faced
- E-Mail Answers
Answer / 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 |
What is the difference between index seek vs. Index scan?
What is the order by used for?
What is policy management?
How to select an exiting database using mssql_select_db()?
What are the different types of sql server replication? : sql server replication
Do you know what are acid properties of transaction?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
Where are stored procedures in sql server?
How to convert numeric expression data types by assignment operations?
How do clustered indexes store data?
In which situation you use Self joins?
1 Answers CarrizalSoft Technologies, HP, TCS,
What stored by the master?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
