Config Issue in SSIS package?
Hi All Created one ssis package using import/Export wizard to move the Access Database(secure database) to SqlServer Database.If I exexute the package through BIDS its working fine.If I add the configuration file the package was failed in BIDS its self.If the unsecure Access datbases its working fine.Please help to fix the issue Thanks CMK
July 13th, 2012 9:57am

Hi CMK, To troubleshoot we need to know the specifics of the issue as 1) Error message 2) SSIS, BIDS versions 3) What did you do to configure the configuration? Please provide all of the above.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 10:04am

you need to manualy add your user name /password in connection strings of access. Miss Never Giveup
July 13th, 2012 10:41am

<cite>www.connectionstrings.com/</cite>Miss Never Giveup
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 10:52am

Hi CMK1, Can you please try setting up your SSIS package configuration as mentioned here & Modify the configuration your way: http://www.bigator.com/2012/01/27/how-do-i-configure-my-ssis-package-2/ And yes, please provide more information as stated by ArthurZ Thanks, Khilit http://www.bigator.com
July 13th, 2012 2:02pm

Hi CMK1, Can you please try setting up your SSIS package configuration as mentioned here & Modify the configuration your way: http://www.bigator.com/2012/01/27/how-do-i-configure-my-ssis-package-2/ And yes, please provide more information as stated by ArthurZ Thanks, Khilit http://www.bigator.com
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 2:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics