I'm going to install sp2 on a test server this week and start checking it out.  I was originally hoping that this issue would be resolved in one of the...

Steve,

Thanks for the reply.  We are currently running SP1 and I wonder if any of these issues have been fixed in SP2?

True, we could go into SQL Server Business Intelligence Development Studio or Visual Studio and create a 'Transfer SQL Server Objects Task'.  However, this would only be ideal if the...

We've seen this as well and we are running sp1. I'd be interested in seeing people's comments on this.

To resolve this issue I had to set the package to run with Windows authentication (causing it to use the SQL Agent service account). Then I set up a...

We are also experiencing this same issue after upgrading to SQL 2005 Standard sp1 on a Windows 2003 server. If any of you have resolved this issue since your...

Yes, it works at the developer site but not at ours.  Do you know what the syntax is for the /decrypt password switch?  I haven't actually been able to find...

I ran the package from a CMD and get the following error: (note I replaced the actual server name and DB name)

Message

Executed as user: "servername"\SSAUser. ....00.1399.06 for 32-bit Copyright...

This package still will not execute as a step in a scheduled job. I've changed the configuration of the SSIS package since my original post and I'm getting a...

Thanks. I will give this a try, though it will need to be a local user since our SQL servers are not on a domain. Is it safe...

Thanks for your reply. I've changed the protection level back to the default “EncryptSensitiveWithUserKey” (I had changed it during troubleshooting). Since this package came from an off-site developer,...

Thanks for your reply. There must be a way to store this password info in SQL Server as opposed to in a flat file. In SQL 2000 you...

Thanks. I found that even though SSIS was installed, the DTSRuntimeWarp.dll was not even present. I reinstalled sp1 and all is well.

Thanks. I found that even thought SSIS was installed, the DTSRuntimeWarp.dll was not even present. I reinstalled sp1 and all is well.

Thanks for your reply. It is definitely installed and the service is started. I will try uninstalling and reinstalling SSIS to see if that helps.