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
- 5447 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 |
How many .ndf files can we create in Sql server 2005?
What is a rownum?
Which sql server table is used to hold the stored procedure scripts?
What are the properties of the relational tables?
How we can compare two database data?
How make remote connection in database?
How to access the inserted record of an event?
Do you know what guidelines should be followed to help minimize deadlocks?
How can delete duplicate records in cte in sql server?
Are connections to sql server encrypted?
Explain the microsoft sql server delete command? : SQL Server Architecture
Which databases are part of SQL server default installation? Explain the usage of each?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
