SSIS Tutorial Part 22 - Read AlphaNumeric Data Columns from Excel ( IMEX=1) in SSIS Package

[@krismaly]

I enjoyed watching this video. It has very good functionality especially when you handle old Excel files. I think one should know this functionality. IMEX functionality explained clearly. I will keep this as my reference. Please don't delete this video. Thanks

[@TechBrothersIT]

krismaly Thanks Kris, Your feedback is really appreciated. I am going to call you our "Super User" if you don't mind:) I was in process of making more videos and I hope you will like them. Will be uploading later today or tomorrow. I have the list of videos you suggested to make as well. If I get time tomorrow, will make some on Redirect rows from different transformations. Here are the videos I am working today How to Create Excel file with Datetime on Each Package Execution in SSIS Package?How to Load Multiple Sheets to a SQL Server Table in SSIS Package?How to Load Excel Sheet Data to SQL Server Table?How to Load Multiple Sheets to Different Tables in SSIS Package?How to Load Data to Formatted Excel Sheet in SSIS Package?

[@anjalisrivastava804]

In lookup transform if we used this ID column to put lookup on some other table where id is numeric, will adding IMEX=1 pose problem?

[@trolldicker3234]

You can also go to the advanced editor and change the data type for the columns right?

[@TechBrothersIT]

That might not work. I will try to do that and see if that works. Give a try and share your experience if you get chance. Thanks

[@trolldicker3234]

Tech Brothers you are 100% right. It doesn't work for some reason

[@TechBrothersIT]

Thanks for the feedback. So our best is IMEX=1 for this scenario.

[@sureshbabuvorganti2152]

hi bro's while practicing this video i am getting doubt. while creating excel connection string.. in columns 'id' for me its showing 'DT_WSTR' but in this video its showing precision. please clarify... thanks

[@himanshuderiya7680]

IMEX=1 it's Only Working when your string data is not in the first 8 rows. @TechBrothersIT You have any other solution?

[@TechBrothersIT]

yes. there is setting guess rows. plz search video

[@gregoriomorales151]

Hello. The IMEX=1 its working only on the fields that has the alphanumeric on the first 8 lines... but when the alpha its after the line 8, it doesnt work. What can i do? Thanks

[@DhanyaGowda-l9m]

Hi, Do you have any solution for this even I have more than 8lines

[@kabza058]

No I still trying to find the solution​@@DhanyaGowda-l9m

[@NasAlo22]

Thank you for help

[@bhakthasingh8198]

very helpful