Are you sure this applies to later versions of Exchange, this explicitly talks about Exchange 2000, does it work with higher versions?

CEWII

No it isn't it uses something else. And truth be told the SSIS service doesn't really do all that much, it is just a little more than a service...

What I've read is you REALLY like session variables, these can be read out at the client end easily, therefore NEVER (is that enough emphasis?) put anything in the session...

You say it pushed 118 records. ok, are you sure of the table? How is the table set in the destination? Explicitly set? Variable? what?

CEWII

You know you could test this yourself without much problem..

With that said, when you reference a package in a SQL Agent Job if it detects that is encrypted with a...

I am not sure it will show up here, but if you look at the local MSDTC you might see a transaction in progress that you can kill. However...

As far as I know you cannot get around this using a single property. You might be able to break a return value down and return it in several...

Dave,

It sounds like you really want to do this. You might be able to get away with it if you do an inplace upgrade on the existing one, but...

And on top of that SB is really fairly easy to setup, the first time is a learning curve but after that it is pretty straightforward..

CEWII

I have not seen anything like what you are explaining. Agent isn't in control of the running of an SSIS package it just calls either the SSIS server or...

I have never seen SSIS do any truncation when the data types were correctly sized. Are you working with these as number data types or as string data types?...

I'm even less sorry about being short now..

Sorry to be a little short, BUT you REQUIRE? Perhaps you are not ready for the tests yet.. How about you get the experience and pass them on...

sjimmo (11/2/2011)

So...

Are you capturing the output from DTSRUN? I'm guessing that will tell you whats going on, it always helped me..

CEWII