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 🙂

Hello SSC,

This issue has been resolved, but it had nothing to do with the excel version. There was a step in the SSIS package that was renaming the excel file...

Hi Phil,

Nice to hear from you. I will try this. I hope you have a great holiday and stay safe!

250 is a lot for a fact table. I had a dimension table that had 573 columns. The problems encountered were during updates due to page splits. So...

Not sure I understand what you are saying Phil.

Ok, good point, we want to make sure that other developers have correct info. I gave the answer to Jeff. Please let me know if it's accurate.

This answers my question....

Thank you all very much for your responses! Mystery solved 🙂

Stay safe folks!

Thank you very much for clearing this up, Michael. Also, thank you to everyone on SSC who commented! I really, really appreciate it! This was very educational for me.

I will...

Thanks Voldemar. I'll save that query. I have researched DMV's, Query store and Data Collector, but my issue is that I am all theory when it comes to CPU, I/O,...