June 23, 2009 at 3:32 am
Iam having my filename as "PR1.6_06-15-2009.xls" in the path. when i try to execute the file using for Each loop Container and setting the file full path (Whole Address of the path), its getting Error .
When i renamed the file as "PR16_06-15-2009.xls" (removing the . Symbol) its working fine. let me know how to proceed?
i cant rename the file because the "PR1.6" is the ProjectNumber which i have to use to map the data to the database.
June 23, 2009 at 4:21 am
Please paste the full text of the error message and describe the point at which the error is displayed.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 23, 2009 at 4:34 am
I have 3 variables
filepath - This is the path i would harcord before running the package (\\Servername\folderName\)
Filename - The data for this variable would be populated from the for loop container( i have set the enumerator to get the filename and mapped to this variable).
filefullpath - This is the combination of filepath + filename variables. i will append this using the VB Script.
For Each loop the filename variable would be changed and i use the filefullpath variable for the Excel object to set the filepath to load the data.
The Data is loaded correctly if the filename has no (.) symbol in between. if the filename is like "Abc.xls" its working fine, if it is "abc.1.xls" its getting error.
June 23, 2009 at 4:49 am
OK, I understand. So I'm guessing that the error only appears during execution of the Foreach loop?
Can you post the text of the full error message - as reported by SSIS - please.
Are you using an Excel connection manager with a dynamic filepath (ie, set by an Expression), or is this error being generated by a script?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 23, 2009 at 5:09 am
yes, its occurs only in execution of for loop.
The Error shown as "[Source - Query [1]] Error: The AcquireConnection method call to the connection manager "ExcelConnection" failed with error code 0xC0202009. "
yes, iam using an Excel connection manager with a dynamic filepath
which is set by an expression and iam not receiving any script error.
Iam using a Script to combine the variables filepath + filename and assigning to filefullpath variables.
This filefullpath variables used in the Excel connection manager.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply