SSIS dynamic mapping of columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS dynamic mapping of columns

26 posts, Page 3 of 3

«««1 2 3

SSIS dynamic mapping of columns

Rate Topic

Display Mode

Topic Options

Author

Message

chad.bindl

Posted Thursday, February 03, 2011 9:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 6:15 AM
Points: 1, Visits: 50

Hello AMTZVA,

For sql 2000, you can use vbscript to manipulate the dts object model. I've used this technique to generate dts packages for 100s of tables at a time. I used the excel vb environment to write the code, then execute it like a macro. Then this code can be easily ported to a custom vb application.

This link should get up started:

http://msdn.microsoft.com/en-us/library/aa176227%28v=sql.80%29.aspx

You can learn more about the object model by setting breakpoints and viewing objects in debug mode.

Hope this helps,

Chad

Post #1058197

kap_gemini

Posted Wednesday, August 24, 2011 5:15 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 9:21 PM
Points: 15, Visits: 175

Great post..Is it possible to share the ssis package. I have the same requirment and would like to experiment with it.

In our case source could be Flat files/RDBMs

KApil

Post #1164561

naveed.khawaja

Posted Wednesday, August 24, 2011 5:24 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 3:59 AM
Points: 20, Visits: 142

I don't have a copy of the package available now, but do check out the images I posted in one of the replies to this thread. Along with the original explanation, they should give you enough information to build the package quite quickly.

Post #1164569

kap_gemini

Posted Wednesday, August 24, 2011 5:31 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 9:21 PM
Points: 15, Visits: 175

thanks, some kind of code would be helpful. Also in my case even Column list is not defined at design time. So I can have 5 column for say Table1 which needs to be mappped to Destination table (DTable1 say), for next run it could be 4 columns. So i am planning to put the intermidate schema first and then put data into destination. Please suggest

Post #1164573

clementhuge

Posted Saturday, December 17, 2011 9:40 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 3:27 PM
Points: 89, Visits: 285

You can use the data flow plus component from cosyrock.
If you only use on BIDS (and not on sql server agent) it is free. You can then do true ETL stuff with a for each loop to each table).
the only thing first is to create the table structure on SQL server or Oracle.

There is a nice small turorial here:
http://www.cozyroc.com/ssis/data-flow-task

Clement

Post #1223487

bill 88428

Posted Friday, March 08, 2013 3:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:20 PM
Points: 1, Visits: 27

Hi,

I resorted to this in the end (INSERT .. OPENQUERY()) although there are some third party custom controls which handle dynamic column metadata.

Seems like a bit of an omission from SSIS as judging from the hundreds of posts on the web a lot of people want to do this and end up becoming rather frustrated.

Thanks for your post.

Post #1428476

« Prev Topic | Next Topic »

26 posts, Page 3 of 3

«««1 2 3

Permissions