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:
>
2012年3月6日星期二
BCP Error w/SQL 2005
标签:
acommand,
bcp,
database,
dbo,
error,
function,
impresario,
lft_gl_posting,
microsoft,
mysql,
oracle,
server,
sql,
table-based,
thisbcp
订阅:
博文评论 (Atom)
没有评论:
发表评论