SURESH0518
asked on
What is the fastest to export output of a storedprocedure to a csv file using PowerShell
I have a SQL SERVER Stored procedure and it takes 4 minutes and output of this stored procedure is around 700k. WHat is fastest way to export to CSV using PowerShell. Any help is appreciated.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think there have been enough answers already that deserve points rather than just deleting the question.
Somebody accepted the proposal for the points split as the correct answer! Probably who posted it.
:o)))))
:o)))))
Open in new window
at the end of your script and change the location to wherever you wish to CSV file to be exported to