How can I achieve this Task?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » How can I achieve this Task?

How can I achieve this Task?

Rate Topic

Display Mode

Topic Options

Author

Message

raghavender.2369

Posted Tuesday, January 15, 2013 2:28 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 3:37 AM
Points: 28, Visits: 254

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

Post #1407108

Phil Parkin

Posted Tuesday, January 15, 2013 3:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 4,324, Visits: 9,664

Have you tried the Import wizard?

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1407136

GSquared

Posted Tuesday, January 15, 2013 6:46 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

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

Post #1407246

« Prev Topic | Next Topic »

Permissions