hi,
my dts has 2 task. the first is an ActiveX (vbScript). it scans a folder
looking for a file. the second task is a sql task, it runs a stored
procedure that does the bulk insert of the file found by the first task.
I need to make the first task communicating the fileName to the second task.
I think I need to use a global variable, but I am not sure if this such
global variable is the means of communication between these 2 types of
tasks - or if it only works for task other then these 2 I am using.
Could you please tell me how to make my first task communicate the file name
to my second?
Thanks