I’m using Excel Application Scope and Read Range activities to load excel files into a SQL database.
I’m getting errors loading into the SQL database because of extra columns and rows in the Read Range variable. For some reason its adding blank columns and rows.
I set the range to “A:K” to fix the column issue but now I’m getting extra NULL rows. The row length needs to be dynamic.
Any help resolving the issue would be greatly appreciated.