Thank you so much for the solution.  It works perfectly.

here is a picture of what I am seeing the preview option.  It has the leading zero missing:

Yet, the OLE DB preview is showing the...

• This reply was modified 2 years, 7 months ago by water490.

thank you for the reply.  I tried that and the consuming app still didn't recognize the CSV.  I figured out what the problem is but I do not know how...

• This reply was modified 2 years, 7 months ago by water490.

thank you both!  it works

• This reply was modified 2 years, 7 months ago by water490.

i found a way better way to do the same thing.

https://analytics4all.org/2018/03/10/ssis-lesson-1-export-to-csv/

it works and its safe.  none of the headaches with the original approach I was trying earlier

while still putting emphasis on what Jeff stated with regards to company data on a local PC I am still supplying what I consider would be the better approach...

It doesn't close any "security hole".  Only the people that can enable it can use it.  Turning it off won't prevent that.

As to your "access denied" error,...

It doesn't close any "security hole".  Only the people that can enable it can use it.  Turning it off won't prevent that.

As to your "access denied" error, where is...

What do I need to do to give SS the appropriate permissions?  I plan to revoke them once the query is done.

I was reading online that xp_cmdshell  can expose me to security issues so is there a safe way to do what I am trying to do?  I found this on...

• This reply was modified 2 years, 7 months ago by water490.

What is the nature of the process that will be using the file?  There's a lot of options to get a table out of SQL Server into a file...

thank you everyone

I got this far but there is no csv file being produced.  Does anyone know why?  I got the script from online.

-- To allow advanced...

• This reply was modified 2 years, 7 months ago by water490.
• This reply was modified 2 years, 7 months ago by water490.
• This reply was modified 2 years, 7 months ago by water490.

the db is 11080.00 MB and the log is 17032.00 MB.  Why do I need the log file?  My DB is backed up so if something happens to the tables...

• This reply was modified 2 years, 7 months ago by water490.

thanks everyone.  i will review and get back to you if I have any questions

Can I change it?  I would like it to grow as the data gets larger...not start off so big and then the data size doesn't justify the db size.