Re: Excel Source Plus to process Multiple Files
215 views
Skip to first unread message
Ivan Peev
Jul 16, 2012, 12:30:30 PM7/16/12
to coz...@googlegroups.com
Hi,
The expression you use below is for setting the standard Excel connection manager. This is not appropriate for COZYROC Excel Connection Manager. Also I don't see RetainSameConnection parameter set either. Make sure you use the correct parameters.
Ivan
On Monday, July 16, 2012 5:20:12 PM UTC+1, (unknown) wrote:
> Hi Ivan,</div>
> 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.</div>
> </div>
>
> Here is the connectionstring expression used.</div>
> "Provider=Microsoft.ACE.OLEDB.<WBR>12.0;Data Source=" + @[User::<WBR>FullSourcePathFileName] + ";Extended Properties=\"" + "Excel 12.0;HDR=Yes" + "\""</div></div>
> </div>
> Two other variables are defined FullSourcePath and MyfileValue . Myfilevalue is mapped as variablemapping to the for each loop. Fullsourcepathfilename expression is fullsourcepath+myfilevalue.</div>
> </div>
> thanks.</div>
The expression you use below is for setting the standard Excel connection manager. This is not appropriate for COZYROC Excel Connection Manager. Also I don't see RetainSameConnection parameter set either. Make sure you use the correct parameters.
Ivan
On Monday, July 16, 2012 5:20:12 PM UTC+1, (unknown) wrote:
> Hi Ivan,</div>
> 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.</div>
> </div>
>
> Here is the connectionstring expression used.</div>
> "Provider=Microsoft.ACE.OLEDB.<WBR>12.0;Data Source=" + @[User::<WBR>FullSourcePathFileName] + ";Extended Properties=\"" + "Excel 12.0;HDR=Yes" + "\""</div></div>
> </div>
> Two other variables are defined FullSourcePath and MyfileValue . Myfilevalue is mapped as variablemapping to the for each loop. Fullsourcepathfilename expression is fullsourcepath+myfilevalue.</div>
> </div>
> thanks.</div>
Reply all
Reply to author
Forward
0 new messages