<div>
<div class="content wysiwyg-content">
I'm trying to run DTS package to transform data from AS400/DB2 via Client Access ODBC ( Ms Windows 2000 Server, Ms SQL 2K, Client Access Driver 4.5) 
 
but the result of testing has messed me up 
 
because when i used this command via SQL Query Analyzer 
 
exec master..xp_cmdshell 'DTSRun /S &quot;MySVR&quot; /U &quot;sa&quot; /N &quot;dtsTEST&quot; /G &quot;{482209FD-0891-11D8-868C-00E0299B4BCF}&quot; /A &quot;G1&quot;:&quot;8&quot;=&quot;20031001&quot; /W &quot;0&quot;' 
 
--it doesn't work-- 
 
 
I wonder why??.. because it can be executed in MS-Dos prompt successfully. 
 
if I type 
 
DTSRun /S &quot;MySVR&quot; /U &quot;sa&quot; /N &quot;dtsTEST&quot; /G &quot;{482209FD-0891-11D8-868C-00E0299B4BCF}&quot; /A &quot;G1&quot;:&quot;8&quot;=&quot;20031001&quot; /W &quot;0&quot; 
 
in the command line. The data comes from AS400 into MsSQL Server correctly. 
 
 
If somebody can help, please give me some advices (urgent!!). 
 
Thanks.
</div>
</div>

I'm trying to run DTS package to transform data from AS400/DB2 via Client Access ODBC ( Ms Windows 2000 Server, Ms SQL 2K, Client Access Driver 4.5)

but the result of testing has messed me up

because when i used this command via SQL Query Analyzer 

exec master..xp_cmdshell 'DTSRun /S "MySVR" /U "sa" /N "dtsTEST" /G "{482209FD-0891-11D8-868C-00E0299B4BCF}" /A "G1":"8"="20031001" /W "0"'

--it doesn't work--


I wonder why??.. because it can be executed in MS-Dos prompt successfully.

if I type

DTSRun /S "MySVR" /U "sa" /N "dtsTEST" /G "{482209FD-0891-11D8-868C-00E0299B4BCF}" /A "G1":"8"="20031001" /W "0"

in the command line. The data comes from AS400 into MsSQL Server correctly.


If somebody can help, please give me some advices (urgent!!).

Thanks.

run DTS Package in Ms SQL Query Analyzer

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.