This is so frustrating now. I created a SSIS package on my developement
machine. But when i want to deploy it on a SQL 2005 server, it failed.
1. This package connects to a 3rd remote database server.
2. When I deploy it, i chose "File system deployment" and "Validate
packages after installation".
3. Then i got error in packages validation:
The AcquireConnection method call to the connection manager "xxxx"
failed with error code 0xC0202009....
4. OK, i searched online, and found maybe it's something about
protection level. So i tried EncryptSensitiveWithPassword and
EncryptAllwithPassword. But none of them works. I got a error msg says
"The protection level of the package requires a password, but
PackagePassword property is empty"................ I just typed this
password in 1 sec before this....
5. And anyway, the result of this deployment is the same as above.
6. Another thing is, should i use XML config file? If I don't use it,
is all configuration saved into the package itself? And it seems
without it, i will lose some additional files.

Someone please help me. This is a extreme simple SSIS, i would guess
everyone is building this. But how do they deploy it onto other
machines, i really want to know.