sql server msde: Help with importing dts package. -- sql server msde

You're in the

sql server msde

group:

Help with importing dts package.

CharlesC
8/16/2006 9:21:52 AM

sql server msde:

Hello,

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

I entered the following dtsrun line (msde 2000 sp3) and received the errors
shown.

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

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? I did not select for ole db provider anywhere.

Thank you.

Re: Help with importing dts package.

CharlesC
8/16/2006 12:05:25 PM

Any help would be greatly appreciated.

Thanks.

Re: Help with importing dts package.

Arnie Rowland
8/16/2006 4:09:33 PM

It appears that DTS couldn't find the file [db.dts].

You need to specify the complete path to the package file.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn