Thanks! You are a Genius!!!

I have edited the the initial post for better readability and I am also posting the create and insert statements below:

CREATE TABLE [dbo].[DocumentHold](

[ReqID] [int] IDENTITY(1,1) NOT NULL,

[DocId] [nvarchar](50) NOT NULL,

[Version]...

I get the following error when I modified it the way you suggested

'An explicit value for the identity column in table 'DGSData.dbo.DocumentHoldBackup' can only be specified when a column list...

thanks for that input!

Silly Me!!!

DECLARE @FileName varchar(50), is the culprit..

I increased the size @FileName varchar(250), and it's resolved!

When I write data into a local drive, I can successfully create the output data file as

'ArchiveDocumentHold_03-13-12.csv'

When I write to network drive, I am able to successfully create the ouput...

thanks a lot, that did the magic! Gave the SQLServiceAcount full permission on the folder and worked perfectly!

Seth, Appreciate your time and inputs, it definetely helped pinpoint the problem!

Yes! I removed the white space in the file path.

But still see the same error.

I already configured it using GUI 'SQL Server Surface Area Configuration'

But to make sure, I repeated it using the commands u sent.

But no luck.. still the same error..

Under...

That's good to know!

Have a question! Where did you run all these statements exactly from?

Management studio?

This is what I am trying to do and I get the above mentioned error:

DECLARE @FileName varchar(50),

@bcpCommand varchar(2000)

SET...

Thanks for the response. I had to slighly modify the query to yield today's results as following:

'bcp "select Col1, Col2, Col3 from x where DATEDIFF(day, add_datetime, GETDATE()) = 0" queryout...

thanks a lot for the quick response and a great solution that looks very simple