DTS SQLServer from .NET

#1

Hello:

I have a web application from where I need to execute a DTS,
my platform is SQL 2000 and .net 2003. From a Vb.net module I want to
execute the package, my question is: does the package need to be STRUCTURED
STORAGE FILE or could it be SQL SERVER package (local to the server) in
order to be executed from .NET.

- If I can execute the local SQL package , how can I do it?
- If I can only execute STRUCTURED STORAGE FILE, how can I get ride off of
the multiple versions that are created everytime the package is opened and I
make any update on it.

Thanks

#2

"Gina Hernandez" <pdwhitt (AT) nospam (DOT) wdsinc.com> wrote

Quote:

Hello:

I have a web application from where I need to execute a DTS,
my platform is SQL 2000 and .net 2003. From a Vb.net module I want
to execute the package, my question is: does the package need to be
STRUCTURED STORAGE FILE or could it be SQL SERVER package (local to the
server) in order to be executed from .NET.

- If I can execute the local SQL package , how can I do it?

LoadFromSQLServer is the methiod to laod a package from SQL/msdb storage.

Quote:

- If I can only execute STRUCTURED STORAGE FILE, how can I get ride off
of the multiple versions that are created everytime the package is opened
and I make any update on it.

There is no way to remove versions from files, you will need to save it to a

new file, or save it to the same file, but delete teh file while the package
is open and in memory.

You can use any storage.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS SQLServer from .NET

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS SQLServer from .NET - 12-21-2005 , 12:09 PM

Re: DTS SQLServer from .NET - 12-22-2005 , 02:58 AM