SSIS DataSet

I have a SSIS package that loops through data from Oracle. Currently I am quering Oracle at each loop to filter data I am experiencing performance issues. So I want to extract data from oracle once and store in a variable using Script Task and loop through the data at that point. Does anyone know how i can handle?
Who is Participating?
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
afaik SSIS doesn't 'do' local tables as variables.

Do you have the ability to write objects to that Oracle db (or any other) where you can optimize?
earngreenAuthor Commented:
I might not be explaining it properly. I am looking for something similiar to the following and putting dsvar in a loop container.
earngreenAuthor Commented:
Added local tables to the database. Unable to handle in memory.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.