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?
earngreenAsked:
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?
0
 
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.

http://sqlblog.com/blogs/andy_leonard/archive/2007/10/14/ssis-design-pattern-read-a-dataset-from-variable-in-a-script-task.aspx
0
 
earngreenAuthor Commented:
Added local tables to the database. Unable to handle in memory.
0
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.