Viewing 15 posts - 331 through 345 (of 3,544 total)
vincentshanecurtis - Monday, August 7, 2017 3:23 PMThanks for the assist.
Your welcome 🙂
Hope it helped.
Far away is close at hand in the images of elsewhere.
Anon.
August 8, 2017 at 1:48 am
Some advice here here please
Far away is close at hand in the images of elsewhere.
Anon.
August 8, 2017 at 1:43 am
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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
Far away is close at hand in the images of elsewhere.
Anon.
August 7, 2017 at 7:42 am
Far away is close at hand in the images of elsewhere.
Anon.
August 7, 2017 at 6:25 am
What version of VB are you using?
In .NET Far away is close at hand in the images of elsewhere.
DBNull.Value returns a correct NULL for procedure calls
Either
Test each control and pass DBNull.Value for empty string
or
Anon.
August 7, 2017 at 6:17 am
EXEC sp_MSforeachtable
Far away is close at hand in the images of elsewhere.
Anon.
August 7, 2017 at 6:09 am
OUTPUT INSERTED and DELETED to a staging table then unpivot that table to the destination table
Far away is close at hand in the images of elsewhere.
Anon.
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.
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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.
Far away is close at hand in the images of elsewhere.
Anon.
August 7, 2017 at 4:39 am
Use OPENROWSET with BULK option
Far away is close at hand in the images of elsewhere.
Anon.
August 4, 2017 at 7:27 am
In group properties click on fx for sort and use the following expression
CInt(Mid(Fields!termName.Value,2))
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
August 2, 2017 at 9:06 am
Viewing 15 posts - 331 through 345 (of 3,544 total)