communication between activeX task and SQL task

communication between activeX task and SQL task

Post by Ramada » Sun, 18 Dec 2005 03:23:57

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?

1. setting sql query of Transform Data Task with ActiveX Script Task inside DTS package?

2. How do I Call/Execute a SQL Task from an ActiveX Task?

Overview of package:


I have a table (Export) that consists of 1 column ExportID. The
package grabs the first ID in the table into a global variable. It
uses this value to grab the data in a corresponding table and then
export that data to a flat file. After the export has successfully
completed, the ID stored in the global variable is deleted from the
Export table. The next step in the package looks at the Export table
to see if another ID is waiting to be exported. If it is, the
ExportID global variable is reset to the new ID in the Export table.

This is where I am at a stand still...I would like to be able to call
the first step in my package to start the whole loop again if there is
a value in the ExportID global variable. If there is no value in the
export table, I would like the package to just finish.

Is there a way to simply call the SQLTask1 so that the process is
started again?

3. How to ensure that ActiveX Script Task runs before Transform Data Task.

4. Email to Task, move task to 'Other Tasks' folder to sync w/Sharepo

5. Printing Tasks and Task Notes More than one task per page

6. Email to Task, move task to 'Other Tasks' folder to sync w/Sharepoint

7. not syncing Tasks that "Regenerate new task after x xxx(s) after each task is completed"

8. start task 3 if task 1 OR task 2 is finished in project

9. Wait for Tranform Data Task Completes Before Running SQL Task

10. Task displays as New Task when I am not a resource for the task

11. [PATCH 07/11] Task watchers: Register per-task delay accounting task watcher

12. [PATCH 07/11] Task watchers: Register per-task delay accounting task watcher

13. Task not appearing, save and close says Task is not in Task folder

14. Tasks in subfolder of primary task folder not visible in Task pad

15. MS Project 2003 AND 2007 - Task ID numbers get rearranged, tasks move, task indents change