If you post a couple of sample rows of data and the DDL for the table you are trying to BCP into, you'll get better help more quickly.

You need to get into the server properties (right click on the server name in SSMS) and change the authentication options on the 'security' tab.

It looks like you are trying to log in to the SA account using SQL Server Authentication and the server is only configured to allow Windows authentication. If you...

Could you add the fully qualified path name for the bcp executable, and an explict server with -S and try it again? And just as a long shot, you're...

I don't think there is anything magical about c:\temp. Does the account the SQL Server is running under have access to that directory? I'd guess that it's more...

I've had the problem with the column metadata reverting too. It usually happens when I've built the package by going through the import wizard and saved it to work...

Is 255 enough? Bumping it up couldn't hurt. Does it match the output column datatype?

So, in the excel source, in the advanced editor, it probably shows a mismatch between the actual column size (which isn't shown anywhere), the external column size and the output...

Are you sure it's choking on the destination? In the advanced editor, you might want to check both the external column and the output column on the excel spreadsheet...

If you print out the string, you'll notice that the SETs look like:

SET @ValueType = RES

SET @Land_Bldg_Both = BOTH

You'll need to add the quotes around the constants in order for...

Leaving aside the question of whether this is a good idea or not, you can use the command line utility SQLCMD to log in to servers and run stored procedures...

And even though my company has some data in the cloud, it's always good to remember that a cloud is, by definition, vaporware.

There are a couple of open source volunteer tracking systems out there. One is:

http://sourceforge.net/projects/vmoss/?source=navbar

I haven't tried it, but it popped up as a possibility when my daughter was looking...

Truncate will probably work, but if you have a torn page you need to do a thorough check on your I/O system to see what might have caused it. ...

Yes, solving the real problem inside the transactions is the right way to handle deadlocks, but if you need a quick band-aid:

Snapshot isolation may impact performance, so you need to...