InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:30:01 GMT20http://www.sqlservercentral.com/Forums/Topic1407108-364-1.aspxIs 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.Tue, 15 Jan 2013 06:46:13 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1407108-364-1.aspxHave you tried the Import wizard?Tue, 15 Jan 2013 03:40:25 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1407108-364-1.aspxHi 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 Tue, 15 Jan 2013 02:28:57 GMTraghavender.2369