I am importing multiple sheets of same excel into one table using ssis.
I am following below flow.
Data flow task->Excel Source->Look up->OLE DB Destination.
I have created a variable(User::Sheet123).
Now, in Excel Source Editor, I am using variable name(User::Sheet123) in Data access mode(Table name or view name variable).
Now the problem is, if i click on Preview, i am getting below error
Index and length must refer to a location within the string. Parameter name: length(mscorlib).
And there is no spaces in sheet names.
My sheet names are
Excel - 2007 and SQL Server - 2008
Please help me.