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

[quoted text, click to view]

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

[quoted text, click to view]
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