Dynamic File Column mapping in SSIS.

Question

Dynamic File Column mapping in SSIS.

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

ghalib.mustafa Valued Member Points: 67 More actions · Answer 1

Hiske Bekkering - Monday, November 19, 2018 1:24 AM
Hi Ghalib,
Of course, you must also set the mapping for Column5!
So in your screenshot of the mappings page, where it says "<Ignore>" you must select "Column5"
Regards,
Hiske

Hi Sir,
Thank-you for your precious time.
Ok, I got it, it is working fine now. But, I was wondering if it is possible to make this more dynamic, as if we don't have to do the step mentioned above or adding output columns to script task. it should just read the mapping from mapping table and map the columns as is dynamically.

Actually, I am looking for the way by which we can transfer our data from source to destination without having the knowledge of data(types/metadata/no of columns)of source and destination.
I am new to this BI field and it's been three weeks since I joined and I see others making new package every-time for different kinds of sources and destinations. I understand that I am not at the level to question that but it is kind of intriguing to me that it is very basic SSIS operation, and it is not dynamic.

Regards,
Ghalib

Hiske Bekkering SSC Enthusiast Points: 141 More actions · Answer 2

ghalib.mustafa - Monday, November 19, 2018 3:49 AM
Hiske Bekkering - Monday, November 19, 2018 1:24 AM
Hi Ghalib,
Of course, you must also set the mapping for Column5!
So in your screenshot of the mappings page, where it says "<Ignore>" you must select "Column5"
Regards,
Hiske
Hi Sir,
Thank-you for your precious time.
Ok, I got it, it is working fine now. But, I was wondering if it is possible to make this more dynamic, as if we don't have to do the step mentioned above or adding output columns to script task. it should just read the mapping from mapping table and map the columns as is dynamically.
Actually, I am looking for the way by which we can transfer our data from source to destination without having the knowledge of data(types/metadata/no of columns)of source and destination.
I am new to this BI field and it's been three weeks since I joined and I see others making new package every-time for different kinds of sources and destinations. I understand that I am not at the level to question that but it is kind of intriguing to me that it is very basic SSIS operation, and it is not dynamic.
Regards,
Ghalib

Hi Ghalib,

Well, it might be possible, although I do not know how to do it.
As my solution fixed the problem I was facing, I did not investigate further.

But perhaps a commercial product such as Cozyroc (as recommended by Mark Tassin) can provide what you want!

Regards,

Hiske

ghalib.mustafa Valued Member Points: 67 More actions · Answer 3

Hiske Bekkering - Monday, November 19, 2018 4:56 AM
Hi Ghalib,
Well, it might be possible, although I do not know how to do it.
As my solution fixed the problem I was facing, I did not investigate further.
But perhaps a commercial product such as Cozyroc (as recommended by Mark Tassin) can provide what you want!
Regards,
Hiske

Hello Sir,

Yes Sir, I am aware that, with the help of Cozyroc we can achieve that as I have seen few tutorials about it, but the issue with Cozyroc is same with me as with you. I am not even Senior SE'r. However I believe, that if Cozyroc can achieve that, perhaps individual can achieve it too, doesn't matter if it is not that fast.
Thank-you very much sir for your time and effort, as you have shown us a way and helped us to attain dynamic mapping and made us believe that it is possible any how. Before this, I wasn't even able to visualize the behavior of package but now I could.
May God bless you for helping us.

Regards,
Ghalib