January 31, 2007 at 8:36 am
I have a package with multiple remote connections. I need to use a SQL task to pull data from a remote db and feed that SQL script by parsing through a globalvariable recordset...
I've tried a different route by using a WHILE NOT rs.EOF WEND loop in an Active Script Task but haven't been able to jump back and forth to the SQL task where my remote connection is.
Am I asking to much of DTS? Maybe going about it the wrong way....
Thanks for any help!
A.S.
MCSE, ASE, DBA
Webmaster
Applications Developer
January 31, 2007 at 9:18 am
I think that I understand what you are trying to do.
You need an activex script that reads one record from the recordset and sets up other tasks based on that value.
I would test for EOF at this point and would set Main to fail
Main = DTSTaskExecResult_Success
I would connect to your next task (whatever you want to do) with a success workflow. Have all of the tasks that work with the current row's data connected with workflow (success or completed, whatever).
Next add another Activex script. It will movenext on the recordset.
Test for eof. If it is not eof then
DTSGlobalVariables.Parent.Steps ("ActivexScript1").ExecutionSTatus = DTSStepExecStat_Waiting
Replace ActivexScript1 with the name of the step used to start the process.
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply