by oded » Fri, 20 Oct 2000 04:00:00
by Carlos Eduardo Roja » Fri, 20 Oct 2000 04:00:00
You can use the dtsrun command line utility. It's documented in the books
online.
This is an example taken from the books online (that runs a package saved in
msdb):
dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name
/Mpackage_password
--
Hope this helps,
--------------------------------------
Carlos Eduardo Rojas
MCSE+I, MCDBA, MCSS
Quote:> I need an explenation about DTS. i am creating a DTS object which send
> my first 25 query results to a file. i saved the DTS in SQL Server (not
> by repostery) and now i need to call it from an application. how do i
> preform this action?
by R. Roger » Fri, 20 Oct 2000 04:00:00
Richard.
Quote:> I need an explenation about DTS. i am creating a DTS object which send
> my first 25 query results to a file. i saved the DTS in SQL Server (not
> by repostery) and now i need to call it from an application. how do i
> preform this action?
by Tore » Fri, 20 Oct 2000 04:00:00
Third possibility: You can use the Microsoft DTSPackage Object Library in
an application.
Article "PRB: DTS Object Model Error Handling Does Not Show the Cause of
Error in Visual Basic" (ID: Q240406) includes an example (VB).
HTH,
Tore.
Quote:> I need an explenation about DTS. i am creating a DTS object which send
> my first 25 query results to a file. i saved the DTS in SQL Server (not
> by repostery) and now i need to call it from an application. how do i
> preform this action?
1. DTS error migrating dts saved to file packages.
Because we use a three tiered architecture of dev, test,
and production as I migrate the DTS saved package from one
platform to another I get the following error:
Error source: MicroSoft Data Transformation Services (DTS)
Package
Error Description. The system cannot find the file
specified.
This happens saving it off to disk on say dev1, ftping or
copying to test1 and then trying to open to migrate to the
test1 environment it won't open and gets the above error
after the -> open pkg (on the target environment), and
that's when we get the error.
Thanks for the help!
Regards.
3. Saving then calling a DTS package.
4. Columns name in alphab.order with ADOX
5. Calling DTS package from DTS package
6. Work Week
9. How do you call or run another DTS from a DTS
10. Calling a DTS package from within a DTS Package
11. Calling DTS application or executing DTS scripts from within Visual Basic
12. DTS Package Save takes too much time when saved and Meta Data Services Package
13. DTS - Runnung DTS inside DTS.