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