OK, tell ya what dude... I'll put that vid together tonight and send you the link in the morning. If I forget to send

you the link just remind me...

Not sure if WMI will create users, but worth a shot. Also powershell should work. I think ADSI only queries though.

Any of these methods could be...

Perhaps run the query a count(*) in a sql task beforehand and only go to the data flow if the count is 0... would that work for you...

I don't know about anyone else, but I need just a little bit more info on the package. What step is it failing on, etc.

However, w/o knowing anything else,...

Here's that video I promised. I've got another one, but it's not ready yet.

http://midnightdba.itbookworm.com/ssisforeachloopintro/ssisforeachLoopIntro.html

Without detailed errors, which the deployment wizard doesn't give, it's hard to say what it could be. But when I've had these problems in the past it has boiled...

I did a video on handling txt file errors.

Check it out if you like...

http://midnightdba.itbookworm.com/SSISTxtFileErrors/SSISTxtFileErrors.html

xml is definitely the way you wanna go.

To do this, go to SSIS\Package Configurations in the top menu.

Then you'll follow the prompts to create the file and choose...

He's exactly right dude... if you have problems getting it to work even then, or you're not able to make changes you need to, then try the fuzzy operator instead....

An easier way would be to attach a function to the control flow...

so where you've got your green arrow coming from the bottom of your rowcount task, you could right-click...

You can't really restore to a specific LSN in the manner you're thinking about. You can restore to a marked trans, but only if you mark the trans in...

Excellent dude!

Yeah, I was afraid of that. Unfortunately I think you're screwed. You may be able to get a log parser and find it, but I really wouldn't hold...

Sorry dude... I really doubt SQL and sybase are keeping the same password algorithms anymore so converting them prob isn't going to be an option. Nor would I hold...

Well, you could make a separate call before and after to give rights and then take them away.

This way you can keep your user and object static, and just modify...