I tried to do the same. Changed the OpenRowSet value to SALES$A2:D101. Now the excel source gives me an error "The external columns of component "Excel Source" are out of aync with data source..."
I am trying to export the top(n) rows from an excel sheet to a flat file.. Need your help
commented on Nov 16 2012 10:24AM