2012年3月6日星期二

BCP Error w/SQL 2005

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!
Adding my managed newsgroup email id.
Steven Bras
Tessitura Network, Inc.
"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!
|||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, Inc.@.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!
|||Thanks! That solved the problem.
Steven Bras
Tessitura Network, Inc.
"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, Inc.@.discussions.microsoft.com> wrote:
>

没有评论:

发表评论