January 15, 2013 at 2:28 am
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
January 15, 2013 at 3:40 am
Have you tried the Import wizard?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
January 15, 2013 at 6:46 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply