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
- 5349 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 do you mean by sql server agent?
How to Debug a Stored Procedure?
What is dbcc? Give few examples.
What is implicit cursors?
What is dimension table? : sql server analysis services, ssas
How can we get count of the number of records in a table?
What is the difference between insensitive and scroll cursor?
What are various ways to enhance the ssrs report?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
Can some one please help with a query which will take only max value of a column in a join.
What are cursors?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
-
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)
