I have to make a small application, which will execute a DTS Package on a specific SQL Server 2000 server.
I'm using Visual Studio 2008 Professional.
The DTS Package is kept in the SQL Server; not in a file.
If it is possible to enumerate all DTS packages found on the server, that would be nice too.
It would be ok, if I can use a stored procedure to execute it,
I've been looking all over the internet (well, more or less :-)), but I haven't been able to find a solution.
If I use DTSRun (on the server), for some reason, it returns only the column names, when the connection (inside a package) points to "." or "(local)".