"Tessitura Network, Inc." wrote:

> In SQL Server 2000, we were able to BCP out of a table-based function with a
> command like this:
> 
> BCP Impresario.dbo.LFT_GL_POSTING(91) out c:\impftp\gl.txt -c -T -STESS3
> 
> The version of BCP.EXE that comes with SQL Server 2005 (2005.90.1399.0)
> raises the following error when attempting this:
> 
>  An error occurred while processing the command line.
>
> Thanks for any help!

>In SQL Server 2000, we were able to BCP out of a table-based function with a
>command like this:
>
>BCP Impresario.dbo.LFT_GL_POSTING(91) out c:\impftp\gl.txt -c -T -STESS3
>
>The version of BCP.EXE that comes with SQL Server 2005 (2005.90.1399.0)
>raises the following error when attempting this:
>
> An error occurred while processing the command line.
>
>Thanks for any help!

"Roy Harvey" wrote:

> Try using the option of specifying a "query inside double quotes" in
> place of just the the table name.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Wed, 21 Mar 2007 09:30:39 -0700, Tessitura Network, Inc. <Tessitura
> Network, I***@discussions.microsoft.com> wrote:
>
> >In SQL Server 2000, we were able to BCP out of a table-based function with a
> >command like this:
> >
> >BCP Impresario.dbo.LFT_GL_POSTING(91) out c:\impftp\gl.txt -c -T -STESS3
> >
> >The version of BCP.EXE that comes with SQL Server 2005 (2005.90.1399.0)
> >raises the following error when attempting this:
> >
> > An error occurred while processing the command line.
> >
> >Thanks for any help!
>