Hi

I have now created a view but I am still havving problems...I using the following syntax:

bcp "SELECT * from

.[dbo].[myviewname]" queryout "C:\WORK\'+@LCAREA+'.TXT" -f c:\work\ASHLEY\MIDAS\midas_bcpformatfile.fmt -T -k

And now I am getting...

I'll give that a try...thanks for the response!

🙂

Thanks alot twillcomp - That has sorted the issue

The process is now working a treat!

Thanks everyone for all your help - You have been Great!!

Hello Jeff

I tried that but I get the BCP error (the one which advises the correct syntax to use) Can you test the command and hopefully provide one that works...

Update - I have got around this for now by adding an additional column and populating the column with a double quote. I then adjusted the command to read:

declare...

OK seems to be nearly working now I am just having trouble inserting the leading quote

I tried running the following:

declare @bcpcommand nvarchar(1000)

SET @bcpcommand = 'bcp "SELECT ""+title,forename,surname,pafad1,pafad2,pafad3,pafad4,pafad5,pafad6,postcode,urn,emailaddress from ASHLEY.DBO.tablename" queryout...

This is very annoying!!

Right I have created the format file in the way you suggested now Jeff (Thanks)

But on trying to execute the following BCP Command:

declare @bcpcommand nvarchar(1000)

SET @bcpcommand =...

From looking in other places for a solution this is what I have so far:

The terminators needs to be :

/t"\",\""

And can do this directly from the BCP command without a...

Hello Jeff

I am not trying to import I am trying to export to a comma delimited Quote qualified text file...

The fields in my table are:

Title

Forename

Surname

Ad1

Ad2

Ad3

Ad4

Ad5

Ad6

Postcode

Email

URN

And need the data to look...

Sorry My bad!!

Right I have created the Format file now (Thanks for the help)

I now need to ensure the file is Comma Delimited with Quote Qualifiers

The format File I have...

Ok I am now trying to run via command line in the following way:

declare @cmdcommand nvarchar(1000)

set @cmdcommand='bcp bicky.dbo.output format nul -c -f bcpformatfile.fmt -T'

exec @cmdcommand

But now getting the following error:...

Tried the latest suggestion but I am still getting the same error - Sorry but this is the first time I have delved into the BCP Format files - But...

Hi all

When I run:

bcp AdventureWorks.Sales.SalesOrderDetail out c:\Currency.txt -c -S student\sqlserver2005

I get the error: "Incorrect syntax near '.'."

So the format file isn't created! I am using SQL Server 2005...

I saw...

Already tried that...Job completes but no notification is sent...

Fair point - Although would be...