I use ISQLW in batch mode to load data from a SQL script. In this step, a GV
is assigned to isqlw. Problem is, I can only run this by manually pasting
isqlw -S phlprdsql01 -d Triactive -E -i c:\temp\triactive\test.sql -o
c:\temp\triactive\test.txt into a cmd prompt. How can I ensure the
automation of this step?

DTSGlobalVariables("gv_isqlw").Value="cmd.exe /c isqlw -S phlprdsql01 -d
Triactive -E -i c:\temp\triactive\test.sql -o c:\temp\triactive\test.txt"

Hello SQLcat,

I am not too sure what you want but it looks as though you are mashing together
ISQL and DTS and want to paramterise the command line string. If this is
the aim then have a look here

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com