Post reply

why we need *Data Flow Task* in SSIS

  • March 19, 2014 at 1:20 pm

    #286832

    Hi,

    I am quite new to SSIS

    Why do we need Data Flow Task in SSIS. -- Is it used to connect two different databases like from Oracle to SQL or from DB2 to SQL

    Currently we are loading data from Oracle database to SQL server database. I see that the previous developer has used DataFlowTask , where-in he uses a OLEDB Source Editor to do a SELECT from Oracle database and uses OLEDB Destination editor to INSERT those selected values

  • March 19, 2014 at 1:35 pm

    #1698506

    Because that's the task designed for that purpose. What else would you use?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply