2012年3月20日星期二
BCP Parameter for Unicode file
Can any one suggest the bcp parameter for importing file , which is in unicode format, delimeted by tabs. i tried -w, -N all in vain :-(
TIA,
sudheerWhat do you mean that the input file is in unicode format?
I don't understand...|||Originally posted by Brett Kaiser
What do you mean that the input file is in unicode format?
I don't understand...
I meant the file is in Unicode format
i m using sql server 2000 .
Error message is
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid
character value for cast spec
ification
and string i used for bcp is
bcp <DBname>..<tablename> in
D:\a.dat -S<servername> -T -m0 -w|||http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9mwg.asp and verify the data in the file against the data type of the columns. This error usually indicates that the data is incorrectly formatted & is failing to get converted.
http://www.nigelrivett.net/BCP_quoted_CSV_Format_file.html for more help.|||Originally posted by Satya
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9mwg.asp and verify the data in the file against the data type of the columns. This error usually indicates that the data is incorrectly formatted & is failing to get converted.
http://www.nigelrivett.net/BCP_quoted_CSV_Format_file.html for more help.
Hi,
thnx for info, i solved the prob. the no.of columns in the datafiles and tht of the target table were not matching.
sudheer|||I still want to know what a unicode flat file is...|||I assume that a Unicode flat file is a fixed width columnar report that contains Unicode (16 bit wide characters) data.
-PatP
BCP Out Command
text file. When doing this is there an parameter to format the data into a
fixed format?
Script being used:
bcp.exe databasename.dbo.table OUT datafile -t
"," -c -CRAW -Sservername -Uuser -Ppassword
ThanksBrent Stevenson (essexbs@.insightbb.com) writes:
> I'm using the BCP OUT command to extract the contents of a SQL table to a
> text file. When doing this is there an parameter to format the data into a
> fixed format?
> Script being used:
> bcp.exe databasename.dbo.table OUT datafile -t
> "," -c -CRAW -Sservername -Uuser -Ppassword
Do you mean a format where each column has a fixed length? You would need to
use a format file for that.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql
2012年2月13日星期一
Batch Printing
are 296 choices for Parm1. Is there anyway to create a batch job to run
this report for all 296 choices and send to .PDF?You could create a data driven subscription that could accomplished
this, although that may be a bit of work. Is the requirement to have
seperate PDF's for all 296? A document map would allow easy navigation
to the 296 different parm values inside one report, and document maps
export over to PDF's.
Matt A
www.reportarchitex.com
2012年2月9日星期四
Basic RS Parameter Question
Being VERY new to RS 2000 (started looking at it a week ago), I need some advice. I have a table that contains a datetime field and I have a report that is prompting for a start date and start time, along with an end date and end time (4 prompts in total). How do I combine the dates and times together to pull into the query filter? Am I even going about this the right way?
Thanks much!
If I am understanding correctly you could do something like in your filters set the
TimeValue(Fields!Example.value) = TimeValue(Parameters!Time.Value)
and you could do that for time and date if you are trying to break apart a datetime field.
Josh
|||u can add the parameters into the SQL code such as :
SELECT * FROM tbl_Name WHEREId=@.Id
The RS refer the @.Id as Parameter.