2012年3月22日星期四
bcp resource file error
Unable to Load BCP resource dll. BCP cannot continue.
Does anyone have any idea what might cause this error?
<d> schrieb im Newsbeitrag news:eWq8%23a82EHA.3120@.TK2MSFTNGP12.phx.gbl...
> I am trying to run a bcp import and I am getting the following error:
> Unable to Load BCP resource dll. BCP cannot continue.
> Does anyone have any idea what might cause this error?
You might have to change your PATH appropriately.
robert
2012年3月8日星期四
BCP Export rowcount
2,698,467 rows, but when I do a row count in the table, the row count is
2,665,081?
The table is being used exclusively by myself, as currently I am the only
user that has permissions to it.
The error log from the BCP export reveals no errors.
This is the syntax of my BCP export:
bcp "cms user messaging archive"."dbo"."ifsmessagesarchive" out "e:\backups\
archive.bcp"
-n -e"e:\backups\error.txt" -q -U[username] -P[password] -S[servername]
Message posted via http://www.sqlmonster.com
did you use "select count(*)" ?
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d5932af1b4344880a6c310e39590d9f5@.SQLMonster.c om...
> Any idea why, when my BCP export completed that it stated it exported
> 2,698,467 rows, but when I do a row count in the table, the row count is
> 2,665,081?
> The table is being used exclusively by myself, as currently I am the only
> user that has permissions to it.
> The error log from the BCP export reveals no errors.
> This is the syntax of my BCP export:
> bcp "cms user messaging archive"."dbo"."ifsmessagesarchive" out
> "e:\backups\
> archive.bcp"
> -n -e"e:\backups\error.txt" -q -U[username] -P[password] -S[servername]
> --
> Message posted via http://www.sqlmonster.com
BCP Export rowcount
2,698,467 rows, but when I do a row count in the table, the row count is
2,665,081?
The table is being used exclusively by myself, as currently I am the only
user that has permissions to it.
The error log from the BCP export reveals no errors.
This is the syntax of my BCP export:
bcp "cms user messaging archive"."dbo"."ifsmessagesarchive" out "e:\backups\
archive.bcp"
-n -e"e:\backups\error.txt" -q -U[username] -P[password] -S[servername]
--
Message posted via http://www.sqlmonster.comdid you use "select count(*)" ?
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d5932af1b4344880a6c310e39590d9f5@.SQLMonster.com...
> Any idea why, when my BCP export completed that it stated it exported
> 2,698,467 rows, but when I do a row count in the table, the row count is
> 2,665,081?
> The table is being used exclusively by myself, as currently I am the only
> user that has permissions to it.
> The error log from the BCP export reveals no errors.
> This is the syntax of my BCP export:
> bcp "cms user messaging archive"."dbo"."ifsmessagesarchive" out
> "e:\backups\
> archive.bcp"
> -n -e"e:\backups\error.txt" -q -U[username] -P[password] -S[servername]
> --
> Message posted via http://www.sqlmonster.com
BCP Export rowcount
2,698,467 rows, but when I do a row count in the table, the row count is
2,665,081?
The table is being used exclusively by myself, as currently I am the only
user that has permissions to it.
The error log from the BCP export reveals no errors.
This is the syntax of my BCP export:
bcp "cms user messaging archive"."dbo"."ifsmessagesarchive" out "e:\backups\
archive.bcp"
-n -e"e:\backups\error.txt" -q -U[username] -P[password] -S[serv
ername]
Message posted via http://www.droptable.comdid you use "select count(*)" ?
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:d5932af1b4344880a6c310e39590d9f5@.SQ
droptable.com...
> Any idea why, when my BCP export completed that it stated it exported
> 2,698,467 rows, but when I do a row count in the table, the row count is
> 2,665,081?
> The table is being used exclusively by myself, as currently I am the only
> user that has permissions to it.
> The error log from the BCP export reveals no errors.
> This is the syntax of my BCP export:
> bcp "cms user messaging archive"."dbo"."ifsmessagesarchive" out
> "e:\backups\
> archive.bcp"
> -n -e"e:\backups\error.txt" -q -U[username] -P[password] -S[se
rvername]
> --
> Message posted via http://www.droptable.com
2012年3月6日星期二
BCP error
Unable to Load BCP resource dll. BCP cannot continue.
Does anyone have any idea what might cause this error?What happens when you run this from the command line?
C:\>bcp -v
You should get something like:
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (c) 1991-1998, Microsoft Corp. All Rights Reserved.
Version: 8.00.382
If you do get that, show us what command you are issuing so we can
troubleshoot further. If you still get "Unable to Load BCP resource dll.
BCP cannot continue." then your SQL Server installation is damaged.
We can then look into this.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
msdn.microsoft.com wrote:
> I am trying to run a bcp import and I am getting the following error:
> Unable to Load BCP resource dll. BCP cannot continue.
> Does anyone have any idea what might cause this error?
>
BCP error
Unable to Load BCP resource dll. BCP cannot continue.
Does anyone have any idea what might cause this error?
What happens when you run this from the command line?
C:\>bcp -v
You should get something like:
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (c) 1991-1998, Microsoft Corp. All Rights Reserved.
Version: 8.00.382
If you do get that, show us what command you are issuing so we can
troubleshoot further. If you still get "Unable to Load BCP resource dll.
BCP cannot continue." then your SQL Server installation is damaged.
We can then look into this.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
msdn.microsoft.com wrote:
> I am trying to run a bcp import and I am getting the following error:
> Unable to Load BCP resource dll. BCP cannot continue.
> Does anyone have any idea what might cause this error?
>
|||I have a different version, do I need a SP applied?
My version is 8.00.194.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Fraser,
Looks like it, install SP3a.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Fraser Michael wrote:
> I have a different version, do I need a SP applied?
> My version is 8.00.194.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
2012年2月25日星期六
BCP derived fields
Pls suggest an idea to import derived fields from the data file to SQLServer2005 using the BCP utility?
eg: in the data file there are
Location UserLocId
USA 1
USA 2
IND 1
IND 2
I have to import Unique usercode like
'USA_1'
'USA_2'
'IND_1'
'IND_2'
If there is any way to upload this using BCP
( updating the usercode after loading will take more time)As you have posted a question in the articles section it is being moved to SQL Server Forum.
MODERATOR.|||
Quote:
Originally Posted by dipu vp
thanx in advance....
Pls suggest an idea to import derived fields from the data file to SQLServer2005 using the BCP utility?
eg: in the data file there are
Location UserLocId
USA 1
USA 2
IND 1
IND 2
I have to import Unique usercode like
'USA_1'
'USA_2'
'IND_1'
'IND_2'
If there is any way to upload this using BCP
( updating the usercode after loading will take more time)
i have not tried this, but here's an idea:
i think you can BCP into an existing table. so your FMT (format file) could be different from that of the existing table structure. can you try to have an format file based on Location, UserLocId structure and have an existing table with an extra calculated filed called UserCode with default value rtrim(Location) + '_' + ltrim(UserLocId )
i don't know if it will work but worth a shot.
2012年2月11日星期六
Basics
Hi there,
I've recently bought Visual Studio 2005, and I got SQL server 2005. I have no idea how to work it. I can't even find where you make a table.
Any basic help about SQL server 2005 is needed.
Thanks,
AliQ
Hello AliQ,
SQL Server Books Online has all the information you need, including tutorials and the like. Perhaps do a google on "SQL Server tutorial".
Cheers,
Rob
Hi AliQ:
To find books online from machines you have installed SQL Server 2005, go to Start -> Programs -> Microsoft SQL Server 2005 -> Documentation and Tutorials -> SQL Server Books On Line.
To start using SQL Server, Launch Microsoft SQL Server Management Studio by:
Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio.
When launched, if "Server name:" field is empty, please try to enter one of the following:
1. your computer name. or
2. (local)
and click "Connect" buttom.
Once when you connected to Database engine, you can create database, table, management database security..etc from here.
To learn more about SQL Server 2005, I'd recommand the following reference from MSDN.
http://msdn2.microsoft.com/en-us/library/ms950403.aspx
Hope this helps. :-)
Thanks.