sql server dts: Hi,

I am trying to programatically run a DTS package from .Net (C#) and and ideally would like to see the "Executing DTS Package" and "Package Execution Results" windows displayed.

I've reviewed dtsrun, dtsrunui utilities and KB319985 articles.

If the dtsrun utilitity had a argument indicating to display "Executing DTS Package" and "Package Execution Results" windows that would be work, but it doesn't.

If the dtsrunui utilitity accepted arguments for the server, package, etc... that would be great, but it doesn't.

I could use the package2Class.execute method with and the events as in KB319985, but would have to write my own "Executing DTS Package" and "Package Execution Results" windows.

So my question is this - does anyony know how to programatically run a DTS package from .Net (C#) and and get see the "Executing DTS Package" and "Package Execution Results" windows displayed ?

Thanks,

Mark

To leverage the MS written windows you need to use SQL-NS to execute the
package as opposed to the object model.

You can use the simple SQL-NS demo project (VB6) that ships with SQL Server
to check this out.

C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqlns


Darren Green
http://www.sqldts.com


[quoted text, click to view]
ideally would like to see the "Executing DTS Package" and "Package Execution
Results" windows displayed.
[quoted text, click to view]
DTS Package" and "Package Execution Results" windows that would be work, but
it doesn't.
[quoted text, click to view]
KB319985, but would have to write my own "Executing DTS Package" and
"Package Execution Results" windows.
[quoted text, click to view]
DTS package from .Net (C#) and and get see the "Executing DTS Package" and
"Package Execution Results" windows displayed ?
[quoted text, click to view]

If you want to see the window as per EM executing the package then you can
probably get what you need from using the SQLNamespace library

Have a look at this

http://www.databasejournal.com/features/mssql/article.php/1486471

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


[quoted text, click to view]
ideally would like to see the "Executing DTS Package" and "Package Execution
Results" windows displayed.
[quoted text, click to view]
DTS Package" and "Package Execution Results" windows that would be work, but
it doesn't.
[quoted text, click to view]
KB319985, but would have to write my own "Executing DTS Package" and
"Package Execution Results" windows.
[quoted text, click to view]
DTS package from .Net (C#) and and get see the "Executing DTS Package" and
"Package Execution Results" windows displayed ?
[quoted text, click to view]