Post reply

Connecting to SQL Server or Oracle using ODBC drivers

  • May 3, 2013 at 4:00 pm

    #272224

    Hi All,

    what odbc drivers should we install to connect to sql server. My scenario is that my source server will be always same and destination may be SQL Server or oracle depending upon the request. can i set up SSIS pkg in such a way that i can change destination to either oracle or sql server by just changing connection string ?

  • May 4, 2013 at 3:47 am

    #1612373

    You require SQL Native client or Microsoft oledn provide for SQl .

    Need oracle client to be istalled on server you need to connect for oracle .

    you can use OLEDB connection or ODBC connection (use DSN)in SSIS to connect to SQL or ORacle

  • May 4, 2013 at 10:44 am

    #1612405

    Yes it is possible .. create a SSIS packege which having both connection . but at a time only one is enable..or create two SSIS Package .. one for SQL and another for ORACLE..

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

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