The script was written in VB so I'm afraid I can't try this. Thank you for your suggestion.

I'm not sure what you mean when you say "In your total columns - you are referencing the dataset column..."

Attached is a screen shot of the Design screen. I am...

I see most of the answers use APPLY.

I'm a bit thrown off because I am use to seeing APPLY being used with a function....
But I think I...

Thank you for the response. I should've update this. I was able change the schema owner and then delete the user.

I read your post earlier today, and I am now able to try your suggestion. However, I am still getting an error. Here is a script of what I tried....

Ok, thx for the clarification.

Hmmm, so is there a reason why the interface allows this kind of redundant display of roles? As a beginner DBA, I found this to...

jamel, I'm having the same issue as you. Did you ever figure it out?

I figured it out from another forum, but wanted to post back and it will hopefully help someone else.

For the indent, put in the following expression in the left padding...

Yes, After much research I did find this out, however, many of the articles that I read didn't really spell out how to implement this IMEX=1 property within SSIS.

I tried...

I realize now that there is an inherent problem with the order of events. I am trying to define the connection string for the log file in the package during...