ssis package properties

• sql Anand

  SSCommitted

  Points: 1597

  More actions

  January 12, 2012 at 2:35 am

  #251277

  Hi

  i create a package in ssis..by using this package i take a data from excel then load that to sql server..now i want to do this same job but i want to load data to oracle..in ssis package i can change servername and databasename in sql server...but is there any way to change sql server to oracle server in ssis

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  January 12, 2012 at 3:40 am

  #1432323

  if you mean destination change from sql server to oracle server then I dont see any reason why you cant.

  Or what alternate your can also do is :-

  keep the dts/ssis as it is. Let the data get imported in sql server and then from sql transfer the data to oracle.

  ----------
  Ashish

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  January 12, 2012 at 6:07 am

  #1432399

  and this link will guide you how to export from sql to oracle :-

  http://www.mssqltips.com/sqlservertip/2011/export-sql-server-data-to-oracle-using-ssis/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=2012111

  ----------
  Ashish