SSIS DataSet

Posted on 2012-08-22
Last Modified: 2012-09-17
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?
Question by:earngreen
    LVL 65

    Accepted Solution

    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?

    Author Comment

    I might not be explaining it properly. I am looking for something similiar to the following and putting dsvar in a loop container.

    Author Comment

    Added local tables to the database. Unable to handle in memory.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now