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...

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...

THANK YOU!

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...

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...

not my first choice to increase the table column size, as there are potential downstream effects....

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...

"bad" data:

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?

thanks

Thanks for your replies, here is one of the error messge from the SSIS Package:

Error: 2013-03-13 05:01:23.75

Code: 0xC020902A

Source: Data Flow Task Flat File...

GOT IT! Thanks to a little help from my friends.....

control panel > admin tools > services > SQL Server (MSSQLSERVER2008) > right click properties > logon > as local...

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...

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.....