Hi,
I'd like to set up a button in a VB.net web application which, when clicked, will run a DTS package to import data from an Excel file into an SQL Server database.
I've created the DTS package using the Wizard and chose to save it as a Visual Basic file. This leaves me with a .bas file but I'm not sure how to call it from my web application. Does anyone know how this is done?
Thanks
SK.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Forget doing it that way.

Save the package either to SQL Server or to a Structure Storage file. You
can then use code from here to fire it.

http://www.sqldev.net/dts/DotNETCookBook.htm

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Simon Keating" <simon.keating (AT) pembrokeshire (DOT) gov.uk> wrote

I have this same need (but using C#) and I'm having problems with it (see
Executing a DTS package from ASP.NET)
I built the DTS package, load it via Interop.DTS COM interface, but when I
execute it fails. I think it is related to a permission issue, because my
package has to access a .txt file in a pubshare (disk access), and it fails
in the datapumptask. I created an empty package and it worked fine. So, my
problem occurs when I need to access a file and I need exactly tha (import
contents of a .txt file into a table in SQL Server).
I'm using impersonation to load package but it fails when executing.

Cristiano Franco

"Allan Mitchell" wrote: