I would like to transfer all tabs data from Excel into SQL Server.
To accomplish this; i created a Excel source and ole db destionation. But i wanted to pass a Excel tab name in a sql variable in excel source (i mean - 'sql command from variable') when i do this then "Column" link in left side throughs an error which we use for column mapping in destination.
In sql variable i tried to save a default value = select * from Tab$ but it does not seem working fine.
can you pls help me out for the same?