I guess my first thought is that if these are all windows machines FTP seems kind of silly. Your whole issue is security contexts..

I would think a Script Task...

I'm just trying to get everything into one place.

It runs ok from BIDS (running as you)

It fails in DTExecUI (running as you)

It fails as a SQL Job (running as a...

As a policy I always try to use trusted connections. When I can't I set the credentials either through a package configuration or adjust them in the SQL agent...

I don't know if I agree about admins decrypting anybodies.

I think the bigger issue is that package protection level is not obvious and the error messages don't clearly...

Since I almost exclusively use trusted connectivity I often set the package protection level to DontSaveSensitive. I use package configurations to set protected information or adjust the sql agent...

I was reading something the other day about using a Ram Disk for tempdb, or at least the first 1GB in the RAM disk. I had this working with...

There is protected data stored in the package and the package protection level was probably set at EncryptSensitiveWithUserKey meaning that the SSIS has to be run as the last user...

I'd start with ScriptMain and yes, it is very limited.

CEWII

I was. I made an assumption of your sex based on name. Since I have never referred to you as anything but Lynn before I gambled..

CEWII

The code she posted would show you. When I did it, I did it the hard way with an ASCII chart that has hex values.. Hers was easier..

CEWII

Off the top of my head that sounds like an ok solution. I don't have a better one. Ugly, but functional..

If I would add something I would probably...

I guess I missed this was a pipeline operation..

Also, I see it is SSIS 2008..

Have you looked at the OLE DB Command data-flow component. You could throw the update...

I believe the answer is no. There is an active MS Connect item requesting it at:

http://connect.microsoft.com/SQLServer/feedback/details/124537/provide-function-to-retrieve-the-entire-call-stack

Which further indicates it isn't available..

CEWII

I think it would be helpful to include the output from the SSIS output window, I'm wondering if there is some other text that might provide some additional insight. ...

GMTA..

CEWII