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
- 5432 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What stored by the msdb?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How to use user defined functions in expressions?
What is tempdb database? : SQL Server Architecture
What are wait types?
How do you create type- insensitive operator?
Can group functions be used in the order by clause in ms sql server?
What are the disadvantages of merge replication?
Where is my database stored on the hard disk in ms sql server?
What is update_statistics command?
How to find tables without indexes?
explain extended properties
Ms sql server index?
What is normalization and its types?
What is a trigger and types of a trigger?
