alter the database to read_write then add the user then change it back to read_only.

Excellent Steve. I've been preaching this reality for a few years now but you summed it up quite nicely. I'm forwarding your column to a few people in this...

Not that I'm aware of. I usually use BULK INSERT VS BCP though.

Typical UNIX files have a single line-feed for each line (row) where Windows uses a CR-LF combination which should be compatible, but make sure the -r parameter is correct...

Some update that was installed earlier caused this.

It's a...

You can use bcp. Use BOL and see how to use it, it is a command line utility.

I assume you know the format of the data in the file, and data type expected in each column.

Therefore I would create a staging table in SQL server, having columns...

You could do this by writing the FTP requests to a table instead of a service broker queue, than have the service poll the table periodically. The downside to this...

Yes, you want to change the nvarchar() to varchar() not the other way around. I thought that was in your temp table?

Not off the top of my head. I've used service broker as a TSQL interface for several back-end web services with excellent results.

If you are not sure how to...

aurato (3/1/2012)

sturner (3/1/2012)

aurato (3/1/2012)

I had a hunch this might be it. Is it safe to...

aurato (3/1/2012)

I had a hunch this might be it. Is it safe to change the...

change the dataype of the sopnumber in the temp table to char or varchar.

A most robust and reliable method to do this is to have a separate process implemented as a service or a scheduled task that pushes the files to an http://FTP...