Hi Jeffery,

Responding here for other users with the same issue....

Changing the commit size and row batch worked like a charm! Plus, I dropped the indexes on the table before loading...

• This reply was modified 2 months, 1 week ago by  Lord Slaagh.

Thank you Jo,

This is very helpful. The recovery Model is set to Simple, so I don't think that is the issue. I will take executing in batches into consideration, the...

Hey Phil,

Thank you. I was missing the plus sign!!! 🙂

It was a silly syntax error!

Thank you all for your answers.

Jeffrey Williams - Thank you so much for the logic and...

Not sure if I posted this on the correct forum. I see an SSIS forum all the way at the bottom of the Forums list. Should I move this? Not...

Thank you, Grant! This was helpful. I did not want to unlike everyone, you guys are great and want to express that!

Hello SSC,

This is strange, I am trying to like these posts, but when I click "like" it sets to "unlike(1)". I do not want to unlike any posts, you guys...

Thank you so much Grant! That's a relief.

I have enough information to present to the DBA group and I learned something.

Thank you again. Stay safe and be well!

Dave

Hi team - I found it. Basically you use the SSIS variables as Ed mentioned. We are using the SSIS variables, but some bonehead aliased them to Value_1 and Value_2....

Thank you very much for your responses.

Would you happen to know which system variable shows which proc executed? That is the main issue.

Options are the Try-Catch block at the end of the procs. Although this is really inefficient, it follows the original design of the ETL job. I think consistency is important...

Hi Phil,

Nice to see you and Happy New Year!

You are correct. The ETL is set up to continue on failure due to the amount of data that is being processed....

Thank you Scott!!

This is exactly what I need.

Fredrico,

Are you suggesting searching in Management Studio or Visual Studio. I am not sure if I have searched the way you are suggesting.

Thank you so much for your response!

Dave

Thank you for your response, but I am looking for a query that searches all stored procedures for the '##' sign. I can't manually check all of them we have...

Awesome! Thank you soooo much for that explanation. I was half right 🙂