Viewing 15 posts - 331 through 345 (of 3,543 total)
I tested your format file on some test data to replicate your error and then my solution which worked without error.
Without seeing the query you are running and the format file...
August 8, 2017 at 1:39 am
SQLNCHAR indicates Unicode (2 bytes per char)
Therefore the host file data length need to be twice the table column size
If your column is nvarchar(510) then the format file...
August 7, 2017 at 8:25 am
Make sure line 24 in your format file has "\r\n" as a terminator
Check your input file is tab delimited and all the rows have 24 columns
August 7, 2017 at 7:42 am
August 7, 2017 at 6:25 am
What version of VB are you using?
In .NET
DBNull.Value returns a correct NULL for procedure calls
Either
Test each control and pass DBNull.Value for empty string
or
August 7, 2017 at 6:17 am
OUTPUT INSERTED and DELETED to a staging table then unpivot that table to the destination table
August 7, 2017 at 6:03 am
If the database recovery mode is Full then do a log backup, restore last good full backup and restore the log to a point before the committed updates.
August 7, 2017 at 5:58 am
That is what is causing the error, either remove the spaces or put quotes around the column names
1 SQLNCHAR 0 510 "\t" 1 "column 1" SQL_Latin1_General_CP1_CI_AS
2...
August 7, 2017 at 5:46 am
As a guess, if you posted part of the file you are using, I would say it is your server column order begin duplicated.
August 7, 2017 at 4:39 am
In group properties click on fx for sort and use the following expression
CInt(Mid(Fields!termName.Value,2))
August 4, 2017 at 6:45 am
On my 2016 server it was not installed by default.
I had to install Active Directory Module for Windows Powershell feature via Server Manager
I do not remember having to...
August 2, 2017 at 9:06 am
August 1, 2017 at 1:39 am
Viewing 15 posts - 331 through 345 (of 3,543 total)