Hi devilsid,

Can you explain me these 2 options by taking an example :

Option 1

I guess you could design a package with various scenarios i.e input file as excel/csv and...

Hi Guys,

My concern was mainly to the scenario where Columns are same but files are different format. Sorry If I confused you in my last post.

Please explain me the resolution...

Hi,

I know how a CASE statement works :-), As you said we can recognize the file format by using CASE but what after that in SSIS. Do we need to...

Could you please elaborate the solution?

Hello Sirisha,

Did you find the solution for this?

Please let me know the approach you used.

Thanks in advance

Thank you so much, it worked. Now I know why I am not selected in that interview :-):-)