I was just looking at my code and it is virtually identical to yours. It makes me wonder about the machine you are working on but even that doesn't...

Is it a simple package or a fairly complex one? I'm wondering if it is verifying the package. I have been playing with programatically walking through a package...

I haven't experienced it incorrectly thinking it is truncating when it isn't. You might try to do a redirect instead of ignore and add a dataviewer to the redirect...

I'm asking if the user has the right service permissions, I am grasping at straws but I don't have anywhere else to go.. As far as GPO I would...

I have to say be careful using that method, depending on how the sproc was written the output can be wildly different from one run to another depending on input...

In SQL you don't access the cached data directly, SQL will use cached data to satisfy queries if it can but you can't say I want to use THIS cached...

Good answer and I don't think you left anything out that I was going to say..

Except a little philosphical point. Multi-layered security is called defense-in-depth, you can't uterly prevent...

You *might* be able to use FMTONLY but the underlying problem is that there is no "contract" from the systems perspective of what the output of a stored procedure will...

It will capture any events it is configured to capture.. I think the original poster wanted to add some additional events at runtime..

CEWII

Unfortunately the "encryption" is pretty weak. Just look at http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2006-08/msg00305.html

To see what I mean..

I haven't tried it so I am taking their word for it.. You are...

Perhaps we didn't understand..

What API are you refering to?

Can you set a variable in SSIS from an API call? If so then you can use expressions. Maybe some...

I did a quick look and played with the config file, logging mode seems to be a boolean and after enabling logging and trying to get it into the config...

In the context of Service Broker you can do quite a bit.

Once you send the message it will likely very quickly be responded to. As far as what you...

Based on what you have described of your process you need to call a bat file and wait for it to complete.. The discussion seems to be about how...

What is their hang-up with the job? Can it be scheduled?

I have one other thought and it is kind of overkill for this but..

You could do it with service...