DataReader Source and variables -
06-20-2006
, 09:07 AM
Hi,
Importing data from Oracle to SQL Server 2005, if my Datareader source is
bigger than 5k rows the perfomance go down, so i want to make the load of it
in a loop container, reading only 5k rows and importing them.
I'm using a DataReader Source in the Data Flow, I have some variables with
the interval values, but i don't know if it's possible to assign them to
datareader sqlCommand. It's is possible to do? or there is another way to do
that?
Thanks and sorry my english. |