Ok... so you don't need the xp_CmdShell example then.

Thanks for response, would you be able to mock up an example of how that can be achieve? I just need an easy way to crank out files based...

Not so good... I somehow missed what the OP had in the first post, which is...

Dell PE T430

2 - Xeon E5-2630 2.4GHz

64GB RAM

PERC H730 Controller 1GB cache

2...

Heh... I just get lucky that wway.

There were some fond memories made back then.

"Bumping" my latest reply because of the forum's "Page 2" problem.

Hah - I've had...

No... it's what happens when you deploy.  The C: drive on the server should be avoided for this type of...

Thank you for the update, Steve.  If they need someone to test, I can help.

Too funny.  A SPAM post was removed but the "Discussion" section still has the title with the SPAM info from the title still intact.  That's another item they'll need to...

Is the "SQL Server" you're testing on also on your laptop?

I can't help because I don't use PowerShell for much but I am curious.  The output file in your original post is "c:\fileloading\rmcstdetails.csv".  Where is the "c:\" drive physically located? ...

I remember when I was a young kid and listened to Walter Cronkite talk about the year 2000, which was decades away at the time.  Once again, it's decades away...

Since MS messed up with performance starting in 2019 and hasn't made it any better in 2022, I sadly pronounce that I Don't Believe Anymore but I keep Doing the...

I'm confused.  You're talking about Oracle but you're posting in an SQL Server 2019 forum.

Since I'm not privy to your previous attempts and have never used "CDATA", what is it...