Thank you, Steve. After all the troubles reconciling different db objects with their owner logins , my login was recreated ( drop/create), and the problem went away.

I was wondering...

Thanks. I was able to go by using RaggedRight. Still, it was tricky: I needed to set row delimiter, it is a property without value by default.

Gary,

I have followed steps you have outlined well, until actually running package under Agent. The error is nondesriptive "The package execution failed. The step failed."

Same is executed ion BIDS OK....

I have used the manifest file to deploy the package on SS-2k5. I tried first from the client box where I created the project. During deployment I got error"Login failed...