Viewing 12 posts - 1 through 12 (of 12 total)
right thanks, as it turns out, I selected too many columns for the bcp_in to handle. I thought it was the line terminator, then re-read SQL from the bcp_out, realized...
February 18, 2019 at 3:49 pm
Thanks ThomA, actually, the only NULL in that row is the [NUM6] [varchar](15) NULL, column. Are NULL values not transferable with bcp?
Hmm, after taking a look at the...
February 17, 2019 at 10:36 am
March 20, 2014 at 2:38 pm
I like the idea of accepting > 30 characters and using TRIM. I'll read up and test that feature.
I believe the UNIX - Windows file transfer my be adding...
March 13, 2013 at 5:09 pm
I think I've got a truncate problem not an ascii character problem. I've attached the problem row, the descritpion appears to be greater than the defined 30 characters in the...
March 13, 2013 at 4:44 pm
not my first choice to increase the table column size, as there are potential downstream effects....
March 13, 2013 at 8:59 am
thanks for the replies, I've attached the properties of the sell descr it is 30 character long...
glad to hear you've loaded the file and your table has that ascii...
March 13, 2013 at 8:58 am
000000000005500549|CeraVe Sunscreen Stick SPF 50Â|00187220801|B|N||0000900153||Y|0.000|0.000|0.000
Are you suggesting I code a loop using replace?
March 13, 2013 at 7:31 am
Thanks for your replies, here is one of the error messge from the SSIS Package:
Error: 2013-03-13 05:01:23.75
Source: Data Flow Task Flat File...
March 13, 2013 at 7:27 am
GOT IT! Thanks to a little help from my friends.....
control panel > admin tools > services > SQL Server (MSSQLSERVER2008) > right click properties > logon > as local...
May 9, 2012 at 2:42 pm
Thanks for the response....
SQL service has full control on the folder (its for the filestream files)
Which id is this? All windows id's have full control on the directory...
May 9, 2012 at 1:05 pm
My id is in the administrator group. And, I was able to attach the other sample DB's just fine. This is a pain! thanks for listening.....
May 9, 2012 at 12:46 pm