Sorry for keep bothering you on the same topic. I am having excel
connection issues on the server when using the reqular excel source , so i
used excel source plus to process contact import. Currently it dosn't
process any file other then the once that is defaulted to in the connection
manager. The retain same connection is set to false. Please Advise/Help.
Here is the connectionstring expression used.
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
@[User::FullSourcePathFileName] + ";Extended Properties=\"" + "Excel
12.0;HDR=Yes" + "\""
Two other variables are defined FullSourcePath and MyfileValue .
Myfilevalue is mapped as variablemapping to the for each loop.
Fullsourcepathfilename expression is fullsourcepath+myfilevalue.