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
- 5532 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
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What do you understand by intent locks?
How to verify a user name with sqlcmd tool?
What is the meaning of sql server?
Explain subquery and state its properties?
Which is the main third-party tool used in sql server?
what type of index will get created after executing the above statement? : Sql server database administration
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is difference between aggregate and analytic function?
Which tools are available to manage SQL Azure databases and servers?
Explain nested join?
Explain primary key, foreign key and unique key?
Explain activity monitors
What is the difference function and stored procedure?
What is ddl command?
