SQL Server Performance Forum – Threads Archive

how to execute DTS package from non-SQL system

HI All, I have one DTS Package which I am using for importing data from my SQL server into excel file. Now I am using this package through "dtsrun", through one machine, where I have installed SQL server Client utilities. My Question is: How can I execute this pacakge from one machine from where I don’t have SQL client. The reason is, I want this package should not be person dependent or machine dependant. Is there any solution like making this DTS package in "exe" or so? If anyone know about this issue, pls share it. Thanks
-Johnson

-Johnson,
To execute a DTS package from command prompt, you need to use dtsrun utility.
So you need to have dtsrun in other machine where you dont have client.
Orelse you can search for some third party tools.

Maybe www.sqldts.com has a solution. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

There are thord party tools like SQL Packer from red-gate where you can create packages.
Otherwise, you have to relay on dtsrun —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

Yes Ranjit, we need dtsrun in the system.
I think it might be installed while we install SQL client/server.
I think we can not just move this file and use it, and it needs supporting dlls and rlls. I think www.sqldts.com has some related stuff.
http://www.sqldts.com/default.aspx?225). But it needs some VB skills too. Instead of this, as Dinesh told, SQL Packager is another tool, but its more into c#. Anyway let me try either. Thank you all
-Johnson

]]>