SSIS Package - Urgent need Help

[vasini]

I have created an SSIS package that works if Windows authentication is selected, but fails upon using SQL Server Authentication. Basically, Its not saving the password for SQLServer Authentication. Can anyone please help me on this ?

[Abhijit Jana]

Are you able to loging into SQL Server using the same User ID or password ? Does that user having permission to access the Data? You can check it from Security Permission. Check the User, which you are using having access permission on that particular database or not. Steps : 1. Goto SQL Server Object Explorer > Security > Logins 2. Double Click on the particular user, that you need 3. Goto User Mapping Tab 4. Check Which Datbases are selected and what role is given to user. 5. Update That's All :-D Thanks.

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article

[leckey 0]

1. No cross-posting 2. Don't use urgent. This is run by volunteers so your cries for time constraints make us want to avoid you.

Back in the blog beatch! http://CraptasticNation.blogspot.com/[^]

[Robin_Roy]

For database connections or any other configurable objects, in your SSIS Package use Configuration File as the value might be changing with environments. In the target envieonment, you just need to update the configuration file and it would work fine.