I am converting our old DTS packages to the new SSIS packages in SQL server
2005 integration services. I must apologize first, becase I am quite a newbe
at this SSIS, so hopefully my question makes sense for you.


In DTS, I had a data driven query task that would use a select statement, to
get a result set. It would then use a cached value in the lookup to
determine what to do. Using this determination, I would then run 1 of 3
stored procedures using the data from the current row.

Now, in SSIS, I am trying to do something simular.

So far, I have a OLEDB source that selects the result set, and an OLEDB
command for each one of the stored procedures that may need to be run for
that datarow.

I am assuming that I need to have a conditional split betwen the source, to
point the proper command, so the correct stored procedure is run depending
on what I need for that data row.

Is my logic correct, or is there a different / better way to do it?
If so, my question is this:
In the conditional split, how do I compare a value in a data row, to a value
that needs to be looked up 1 time, somewhere else (from a different data
source). Then determing what needs to be done, pointing to the proper oledb
command for the proper stored procedure.

Any help would be appreciated.
-Ryan

Ryan wrote:
The logic makes sense. You could use a lookup to get this one value from
elsewhere, but since you say it is one valu ethat does not change, I
woudl use an Execute SQL Task to get the value before the Data Flow, and
store in a variabe. The Conditional Split expression can reference
variables.

You may like to try microsoft.public.sqlserver.integrationsvcs for SSIS
questions rather than a DTS group going forward.


--
Darren
http://www.sqldts.com
http://www.sqlis.com