Viewing 15 posts - 2,521 through 2,535 (of 4,272 total)
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...
March 10, 2010 at 4:30 am
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...
March 9, 2010 at 8:28 pm
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...
March 9, 2010 at 8:18 pm
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...
March 9, 2010 at 8:15 pm
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...
March 9, 2010 at 8:07 pm
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...
March 9, 2010 at 8:05 pm
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...
March 9, 2010 at 7:48 pm
I'd start with ScriptMain and yes, it is very limited.
CEWII
March 9, 2010 at 7:23 pm
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
March 9, 2010 at 3:35 pm
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
March 9, 2010 at 3:04 pm
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...
March 9, 2010 at 2:39 pm
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...
March 9, 2010 at 2:29 pm
I believe the answer is no. There is an active MS Connect item requesting it at:
Which further indicates it isn't available..
CEWII
March 9, 2010 at 1:53 pm
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. ...
March 9, 2010 at 1:43 pm
GMTA..
CEWII
March 9, 2010 at 12:40 pm
Viewing 15 posts - 2,521 through 2,535 (of 4,272 total)