Help with dtsrun and dts package.

Hello,

I used SQL Server Enterprise Managers' Export Wizard with destination ODBC
driver for SQL to create a dts package in the structured file format.

I entered the following dtsrun line (msde 2000 sp3)

dtsrun /S servSQL /U sa /P thepw /N db.dts

and received the errors shown.


Error: -2147217900 (80040E14); Provider Error: 1462 (37B6)
Error string: The specified DTS Package
('Name='db.dts';ID.VersionID={[not specified]}.{[not specified]}' does
not exist.
Error source: Microsoft OLE DB Provider for SQL Server


What am I doing wrong? Any help would be appreciated.

Thank you.




.

Relevant Pages

  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Re: export access to sql server
    ... i followed article from sql server books MSDN. ... Running a DTS Package Saved as a Visual Basic File ... Actually my software will support access ... If the app needs to dynamically recreate the ...
    (microsoft.public.vb.general.discussion)
  • Executing a DTS package from a Web application.
    ... Can a SQL Server 2000 DTS Package be run from a Web application? ... The SQL Server database is not local. ... Package Execution Lineage: ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Problem General Network error
    ... Charles Kangai schrieb: ... Author of Learning Tree's 4-day course: "SQL Server 2005 Integration ... email alias: charles ... we are using SISS package (no DTS package sorry). ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Problem General Network error
    ... Charles Kangai schrieb: ... Author of Learning Tree's 4-day course: "SQL Server 2005 Integration ... email alias: charles ... we are using SISS package (no DTS package sorry). ...
    (microsoft.public.sqlserver.dts)