views:

70

answers:

2

I got the problem having written a little procedure to import some flatfiles in a table using openrowset...bcp... which didn't work at customers site.

A short check with bcp /? shows a different behaviour e.g. the switch -T was not trusted connection but rather something with Images.

Are there different versions of bcp delivered?

+1  A: 

I don't think there are different versions of bcp for a specific SQL Server version. And, the -T option as the trusted connection switch has existed in many SQL Server versions.

Are the SQL Server versions the same on each system?
Are the bcp versions the same on each system (run bcp /v)?
Can you give more information about what you see with the image-related output?

bobs
I will try to get the version-information of the bcp - tool at customers side. It's a sql2008 installation.
Ice
A: 

i got the answer: It was the commandline-tool in a sybase environment. There are two management studio's side by side and the last one has set the environment-variable path...

Ice