Yes - thank for putting this together Steve, it's been fun! I am pleasantly surprised to not be mathematically eliminated...yet. Of course I may be...haven't tried to do...

Sounds fun - count me in!

Quoting @BrentO's reply to my similar question to him:

"If you're using the maintenance plans built into SQL Server, then they're rebuilding every index every time, whether it needs it or...

blow away your destination file (on the file system as well as within your data flow) and destination connection manager. create a new destination file within your data flow...

Sorry I won't be able to give you a reason why this occurs, but I got around this problem by simply putting the data into the desired format and having...

in a nutshell, the name of the columns in your data source has changed since the package was last run/created and the column metadata is out of sync. paraphrasing the...

after reading your problem again today and reading paul's response, i see i misinterpretted your need. i agree with paul's response. paul states correctly:

"Since SSIS moves data through...

if at this point you could write an sql statement to update your records in an sql tool outside of ssis (ssms?), then i would try to use an ssis...

beleve it or not, that actually makes sense to me as i had that issue about a year ago on client site, i completely forgot about that until i...

i'm not quite sure i followed your question completely, but my iterpretation of your issue is that you've created a NULL column you want to fill with data later in...

i might be misinterpretting your problem, but the way i read it is you have an ssis package on server1 that you wish to move to server2. you are...

is that the only error you see?

can you please post the entire output - information messages, warning mesages, and error messages all the way to the ...[finished/failed with code blablabla]

my...

try without user::. just use your variable name.

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

'Initialise the variable

Dim vars As IDTSVariables90

'Lock a variable so that we can write to it

Me.VariableDispenser.LockOneForWrite("varFoo",...

not sure if this will work (don't have time to test it myself right now). replace single tick (') with two single ticks (''). note: not a double tick...

you need to add and configure a destination for your redirected rows. right now you've set your error rows to be redirected, but you haven't told ssis where you...