February 28, 2012 at 3:14 am
And the expressions that you use?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 28, 2012 at 8:44 pm
Have attached screen shots of my pacakge , which also shows the expressions of the connection managers. Please do check and let me know if you need any other info to solve this .
February 28, 2012 at 11:31 pm
Your expressions are all wrong. (There's a reason I asked for them 3 times)
You only need the Excel connection manager. Drop the other one.
On the Excel connection manager, you only need one expression, which is on the ExcelFilePath property. This should contain the exact filepath to your Excel file. In your case for example:
G:\EXCEL TO SSMS\wave2_CM.xls
(is G: a mapped drive? If yes, use UNC paths instead)
You can configure the expression as follows:
@[User::Excel_Directory] + @[User::Excel_FileName]
@Excel_Directory is a variable that contains the value G:\EXCEL TO SSMS\.
@Excel_FileName contains the name of the current Excel file and is populated by the outer For Each Loop.
Then you need to put an expression on the Excel Source component. The table that you select in the editor is the sheetname where you want to import data from. So choose the option Table Name or View Name from Variable. Select the variable that contains the sheet name.
My question remains: how will you populate this variable with the current sheet name?
Also be aware that the schema should be identical in every sheet and in every Excel file, or your dataflow won't work.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply