How can I achieve this Task?

• raghavender.2369

  SSC Eights!

  Points: 833

  More actions

  January 15, 2013 at 2:28 am

  #287599

  Hi All,

  How to create a Table dynamically based on the metadata of Oracle Source Table In SSIS(I get the meta data through linkedservers). Suppose i have one Table it contains 20 columns with different datatypes . so i need to create table with the 20 columns with Sqlserver datatypes.

  Thanks in advance

• Phil Parkin

  SSC Guru

  Points: 246986

  More actions

  January 15, 2013 at 3:40 am

  #1577226

  Have you tried the Import wizard?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 15, 2013 at 6:46 am

  #1577323

  Is this something you need to automate so it can be repeated, or something you need to do once (or infrequently)?

  The best method will depend on the answer to that question.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon