• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

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?
0
earngreen
Asked:
earngreen
  • 2
1 Solution
 
Jim HornMicrosoft 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now