Hello,
I'm calling a dts package inside a Stored proc (exec
xp_cmdshell..dtsrun)and I'm getting an error: Error: -
2147217900 (80040E14); Provider Error: 14262 (37B6).
Microsoft said they have fixed this bug in the sql server
2000 sp2 release. We are using sp3 but I still get this
problem. The workaround talks vaguely of putting a white
space in all the parameters. I tried all possible
combinations of that but it fails. Had anyone tried
running DTSRUN in the command prompt? You mind posting a
sample here? Here's what I'm running at the command
prompt that fails:
dtsrun /SCHDSRsql01 /E /N"MonthtlyExtract" /G"C970BA63-
1683-4175-A3C2-F4CED53D66F5" /V"ED1B77FB-9A5B-4694-A1A5-
2F347594BD25"
I'd appreciate any help you can offer.
thanks in advance.

I personally never use the /G and /V parameters simply because I always want
the latest version of my package. If you are having problems then try
having the DTSRUNUI generate the syntax for you.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


<anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks! I'll try to make it more simpler, if it will
still fails, I'll use the DTSRUNUI.