I am passing a SQL task recordset to a Global Variable. I know the SQL task returns 8 records. The data type gets set to "Dispatch" on the Global variable which I understand is correct after the first save and run of the package.
Well If i output the Variable into a msgbox string it only outputs 4 records. It is always the same exact records no matter what.
I can't seem to figure out why it is not outputting all the records to the variable. I am going to use this variable to pass to a transformation task and loop back for each of the records.
I am running SQL SErver 2000. Any ideas as to why it only outputs 4 records to the Global Variable?
Thanks,
Jon
Well If i output the Variable into a msgbox string it only outputs 4 records. It is always the same exact records no matter what.
I can't seem to figure out why it is not outputting all the records to the variable. I am going to use this variable to pass to a transformation task and loop back for each of the records.
I am running SQL SErver 2000. Any ideas as to why it only outputs 4 records to the Global Variable?
Thanks,
Jon