Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



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 are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,


1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  


How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,


Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  


Explain aggregate functions?

0 Answers  


Explain the truncate command? : SQL Server Architecture

0 Answers  


What is the cartesian product of the table?

0 Answers  


If the job running very slow what is the action you do

0 Answers  


What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,


What is BLOCK statements in SQL?

0 Answers   HCL,


Can you explain the role of each service?

1 Answers  


Categories