Hi folks, I have a 2012 sql and it works very fast, one of the most used queries is a table function. This function over time becomes slow and...

I imagine that you've called your variable something like 'FileName', and not "C:\SCRIPTS\SQLServersExport_20191007.csv"!

Thus, I suspect you need to revisit the various relevant properties in your package components, looking for incorrect...

Please expand on what you have provided, to include

a) Your question

b) Which line throws the error, and an outline of what you are trying to achieve

C#, maybe.

As long as max level is the same for all of the lowest-level items, that is. Otherwise, it gets trickier.

Add hierarchy level to your CTE and base your selection on that?

Why do you refuse to format your code?

Your SELECT should be outside of your WHILE loop.

We have a dumping ground Utility Database here and it works well.If you can try and get him to come around to the idea, you'll likely start finding other...

Phil, I agree that the table should be declared outside of the...

Shame about your DBA. A Utility database is a rather good idea, in my opinion – I'm with Thom about not putting non-system objects inside system (or pseudo-system) databases. With...