Wednesday, June 16, 2010

SSIS Extracting Reading from Oracle 10g






  1. Hello,

    I am a newbie to SQL server. Currently we source table from oracle and drop/create in SQL server using manualy generated SSIS package. Problem is when something changes in oracle, SSIS doesn't reflect the new changes. Is there a way to auto generate SSIS pakcage?


  2. Unfortunately there is no way to auto-generate a package (without a lot of effort and in an unsupported manner). Just as you could with most OOP or scripting languages you could create a script task using VB.NET or C# to programatically extract the table definition from the Oracle database and build the SQL Server create scripts based on this definition.