1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / guest


How to give a user the option of importing Excel and a delimited text file into a SQL Server Datab..

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

Post New Answer

More SQL Server Interview Questions

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

How to create prepared statements using odbc_prepare()?

0 Answers  

Is null in sql server?

0 Answers  




What is wide table?

0 Answers  

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

How connect excel to sql server?

0 Answers  

How to remove duplicate rows from table except one?

0 Answers  

How to return the second 5 rows in ms sql server?

0 Answers  

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

For more SQL Server Interview Questions Click Here
Categories