Ok, the name is a little cheesy, but, has anyone heard anything good bad or otherwise about http://www.hostmysite.com

$30 per month includes a small SQL database and 24/7 tech support.

Thanks,

John

Believe me. I'm looking for a new hosting provider. 🙂

Hmmmm ok. How long would that run with a 56K modem and a 25 MB database?

I know I'm being a jerk. That would be a solution....

Ok, so I was a bit lazy with the quotes. This actually works.

declare @sql nvarchar(1000)

set @sql = 'select ''"'' + cast(id as varchar(1000)) + ''"'', ''"'' + name +...

I don't see a switch. It could be done in a query using queryout 'select "' + Fieldname + '", ...

How badly do you need this and why?

...

Bill,

Run each BCP command separately in a DTS package. Add a workflow between each of them. On Success, go to the next.

Good luck

John

Is the error coming from SQL or IIS? When does it error out?

Then add an ActiveX script task to your DTS package and use FSO from there.

To play devil's advocate for a minute... How would you go about backing up a database if the limit of your rights on the server is dbo in that database?

...

Here is an excerpt from their terms of service:

>We are not responsible for loss of customer content due to server or hardware failure. We do, however, backup our systems...

BCP stands for Bulk Copy Program. It's a command line utility that comes with SQL Server designed to import and export data between SQL Server and text files. ...

Andy,

I've created and executed DTS packages both in an exe on the client box and in a middle tier dll in MTS. In both cases, the client machine's processor...

Jim,

Where is this counter variable value? SQL Server Agent is the best scheduling program I've had the pleasure to work with, but, it does not have access to variables...

If you really want to debug the error, please post your complete connection string (less login and password of course) and recordset property settings. The error number might also...

Thanks Steve. That makes sense. My Network guy didn't think it would work that way, but I have a feeling it will. I'll let you know if...