Hi Dev,

Thank you for answering! In SSMS the stored procedure returns the correct results it is just when I try to create a report from it in BIDS that...

Thank you for your help, I have now figured it out and understand it with your help. I appreciate it.

I have it figured out. Thanks anyway!

MrDenny, thanks for continuing to try to help me.

This is my exact code that I am copying to the dos command prompt

bcp DimProducts in Documents\DimProducts.txt -T -c

This is...

I can not get this to work for nothing. I tried putting the code in the command prompt and it just keeps opening up the data in notepad.

I apologize here is the error message.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '.'.