Relation Ship? Does that boat stop at hedonism in Jamaica...lol

Any dea how to set a user variable's value inside the Input0_ProcessInputRow funtion?

Many Thanks

My mistake, I meant to say it was restoring to the backup file after disabling the SQL Server Agent

I disabled SQL Server Agent and it seems to be backing up now.

Luckily I have the data in a flat file. I'll just recreate it. Just thought it would be nice if there were sort of like a "Recycle Bin"

I need the record ID inside the ssis pkg so that I can send it along with the error records in an error table. I've pretty much decided to send...

Yeah its in a script transform in a data flow component. I basically need a way to add a unique record id for each record. I'm open to any way...

Thats true. I now use a 32 bit machine and was using a 64 bit machine before.

I figured it out. I actually did as the error said to do. I opened the script where I can see the code and ran clicked on build and let...

When I recreate the index are the primary constraints and unique constraints recreated as well or do I need to run a script to recreate them as well?

I run an...

Thanks

Is there a way to look into the log files and see who and what happened?

I'm not very familiar with replication however I do know that we aren't distributing the data to multi servers. Everything is on one server.

Someone was working on setting the cascading deletes but if that was the case wouldn't the junction tables be empty as well?