I have a very simple DTS job that takes one parameter
(Global Variable) and uses this parameter in a simple
select call to a DB2 table. The returned data is then
inserted into a SQL Server table.

Everything works great when I use DTSrunUI to execute
this job. I can even grab the command line syntax using
the Generate button:

DTSRun /S "(local)" /N "ProviderByMPIN" /G "{9F92449C-
4C03-4DA8-91A1-
40602C9AE668}" /A "MPIN":"3"="101" /W "0" /E

When I try to execute the command line syntax from a
command line I get a "General Error -2147217845". I have
also tried to execute it using the xp_cmdshell with no
success. I am not why it would work when called from the
GUI and not from the cmd line.

It runs to completion (inserts 0 rows) when run from the
cmd line and the Global Variable is set to a value that
does not exist on the DB2 table. Not sure why this does
not generate the error. Perhaps this is somehow related
to the OLEDB provider. I am using an IBM OLEDB provider.

Any ideas?

Thanks.
-Scott