SSIS writes username instead of service account during registration

Question

I implemented the SSIS 2008 package using BIDS. My package currently logs exceptions and information in the database. I am running the package through SQL Job. I configured the job to run using the service account. The problem I ran into is that when the logs are being written, I see the Windows credentials written to the username column, not the service account credentials. I am doing work through SSMS using my Windows credentials. I was told that Jobs would work through any DBA guy, and they might not log in using the service account.

Below are the steps that I completed to complete the job as a service account.

• Created credentials with a service account as an identity.
• Created a proxy associated with credentials.
• Configure the task to use the proxy account.

Below is the connection string from my package. I removed Integrated Security = SSPI; and provided the user ID and password of the service account, but received an error message with an incorrect login.

<DTS:Property DTS:Name="ConnectionString">Data Source=xxxxxxxxx;User ID=;Initial Catalog=xxxxxx;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=xxxxxx-{452DA0BD-2ACF-4780-9DB0-5A64ABB406A1}xxxxxx\xxxxxx.xxxxxxx;Auto Translate=False;</DTS:Property> 

Another thing I noticed is the name of the creator in the package, which has my Windows username in it. I tried updating this but no luck.

Errors are logged using event handlers

Event handler

Connection string in dtscConfig file

 Data Source=xxx\xxx;Initial Catalog=xxx;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=xxx\xxxxxxx;Auto Translate=False; 

Answer 1

I fixed the problem. I pass the system: username in the stored procedure parameter that solved the problem