In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn " Why do we add IMEX=1 to extended properties of Excel Connection Manager to read Alpha-Numeric Data"
Read AlphaNumeric Data Columns from Excel ( IMEX=1) in SSIS Package - SQL Server Integration Services ( SSIS ) Tutorial
Check out our other related posts/videos on Excel Source And Excel Destination
- How to Create Excel file with Date-time on Each Package Execution in SSIS Package?
- How to Load Multiple Sheets to a SQL Server Table in SSIS Package?
- How to Load Data Excel File to SQL Server Table and Solve Data Conversion Issues?
- How to Load Multiple Sheets From Multiple Excel Files to Different Tables in SSIS Package?
- How to Load Data to Pre-Formatted Excel Sheet (Excel Report) in SSIS Package?
- How would you split Full Address Column into Multiple Columns in SSIS Package?
No comments:
Post a Comment