Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Column mapping Expand / Collapse
Author
Message
Posted Thursday, January 30, 2014 12:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 6:19 AM
Points: 3, Visits: 9
Hi everyone,


Ok so here is my situation.

I have files in a folder.

I am loop through a resultset which has the file names as one of the fields.

When I get the current file,

I want to be able to alter the column / transformation mapping based on the mapping table.

The reason for this is that all the files don't have the same column order.

Firstly, can this be done in SSIS?

Secondly, how would I go about it

Finaly, can you show me an example of that if it is possible.

Thank you.


Post #1536186
Posted Thursday, January 30, 2014 3:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,208, Visits: 9,172
Please do not crosspost. It wastes peoples time and fragments replies.
I responded in your other thread:

http://www.sqlservercentral.com/Forums/Topic1536210-364-1.aspx




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1536222
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse