Re: Help with dtsrun and dts package.
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Thu, 17 Aug 2006 07:22:46 -0600
You want to use the /F option instead /S /N etc and then put
in the file name with full path to the DTS structured
storage file. Something along the lines of:
dtsrun /F"C:\SomeFolder\SomePackage.dts"
-Sue
On Wed, 16 Aug 2006 17:38:18 -0400, "CharlesC"
<Charles@xxxxxxxxxxxxxx> wrote:
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.
.
- Follow-Ups:
- Re: Help with dtsrun and dts package.
- From: CharlesC
- Re: Help with dtsrun and dts package.
- References:
- Help with dtsrun and dts package.
- From: CharlesC
- Help with dtsrun and dts package.
- Prev by Date: Help with dtsrun and dts package.
- Next by Date: Re: Help with dtsrun and dts package.
- Previous by thread: Help with dtsrun and dts package.
- Next by thread: Re: Help with dtsrun and dts package.
- Index(es):
Relevant Pages
|
