> I am building a DTS package that will transfer data from an Oracle
> server to a local MSSQL server. I have the data transformation task
> almost complete and working well, but the SQL query still needs to
> take a "batch" string parameter.
>
> I need to loop the transformation task each time for however many
> batch strings are returned in another query.
>
> I thought of using a Dynamic Properties task to store the batch taken
> from a query in a "CURRENT_BATCH" global variable, but this only seems
> to allow a query that returns a single line. I need to get an unknown
> number of lines from a subroutine-type query and loop my main query
> for each row returned. What is the best way of doing this?
>

On Jun 29, 2:58 am, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello skica...@gmail.com,
>
> Would this article help any?
>
> http://www.sqldts.com/298.aspx
>
> --
>
> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>
> > I am building a DTS package that will transfer data from an Oracle
> > server to a local MSSQL server. I have the data transformation task
> > almost complete and working well, but the SQL query still needs to
> > take a "batch" string parameter.
>
> > I need to loop the transformation task each time for however many
> > batch strings are returned in another query.
>
> > I thought of using a Dynamic Properties task to store the batch taken
> > from a query in a "CURRENT_BATCH" global variable, but this only seems
> > to allow a query that returns a single line. I need to get an unknown
> > number of lines from a subroutine-type query and loop my main query
> > for each row returned. What is the best way of doing this?