January 23, 2009 at 8:34 am
I have a new install of 2005 32 bit (not an upgrade of SQL 2000). I used the wizard to import one SQL 2000 DTS. I can run it from MS. When I try to run from command line (utlimately want to schedule this as a SQL Agent job) I get:
dtsrun /S localhost /U sa /P mypass /N "msdb/contact export to Access MDB 2"
DTSRun: Loading...
Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)
Error string: The specified DTS Package ('Name = 'msdb/contact export to
Access MDB 2'; ID.VersionID = {[not specified]}.{[not specified]}') does not ex
ist.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
I can see the package under legacy. The name is correct.
January 23, 2009 at 8:46 am
I added in package guid and version guide, no dice there.
DTSRun: Loading...
Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)
Error string: The specified DTS Package ('Name = 'msdb/contact export to
Access MDB 2'; ID.VersionID = {2E953B5B-B23A-4B21-9E7B-EBE174BFEF77}.{C64F33AE-
D6B7-40E5-8B54-BF15C16522AC}') does not exist.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
January 23, 2009 at 8:56 am
Is "msdb/" part of the package name or are you indicating that it's stored in msdb? If it's the latter, you don't have to specify that.
Greg
January 23, 2009 at 9:07 am
Yes msdb is not part of the name. Thank you that did it.
January 23, 2009 at 9:17 am
You're welcome. Pay it forward.:)
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply