Login, Logout, and Login Failed. But if you are getting the failures from the log I'm not sure you need to trace it.. Your errorlog should show the...

Sounds good..

CEWII

Using out of the box components you can't. Sorry.

Good luck.

CEWII

All true, however, I believe you can get them to do a batch commit. It is very important to keep in mind that different destinations in a data-flow, even...

I believe you can accomplish either.

CEWII

SSIS won't do this automatically for you. I don't think the boolean is a good idea because it requires a write back to the table and I can think...

Good enough for me..

CEWII

Since I haven't actually done this myself.. The only question that comes to mind is tied to assigning those drives to a resource group. Doe it want drive...

I'm wondering if any of the "regulars" would be interested in peer-reviewing an article related to SSIS processing concurrency. I've had a lot of questions lately in regards to...

I'd bet money that you could. The Script environment has most of the functionality available. You can Create a class inside the script with the same name as...

Ok, I think that clears some things up for me..

I would probably use a Script Task in the SSIS package to behave in the same way the desktop app did...

Express doesn't have SSIS available, no version below Standard does (Developer Edition is technically Enterprise Edition so it doesn't count).

Developing in Dev edition is no problem..

As far as sending to...

For me the question isn't how big can they get but what are YOU using them for. The nvarchar(1000) suggestion may be overkill for what you are doing. ...

We don't have enough information. Please provide the error you are getting. I don't understand this statement "Everytime I make a change in the package or in the...

Yes, I'm not aware of a way to change it. Even accidently..

CEWII