Unable to bulk load data

[Stejawh]

Hi,

We've got a macro that runs a Table Only Publish. 

On external Job Servers the macro falls over with the following message:

bcp.exe is used to bulk load data for SQL Server

What am i missing on my Job servers?

Thanks,

Steve

[ducthcogtechie]

sql server management tools will include bcp.exe

[StuartS]

Hello

I has a simliar problem and fixed it by installing the SQL Native Client.

[Stejawh]

 Hi,

I've installed what i need from the Management Tools and it has cured my initial error.

However now the Jobserver picks up jobs and seems to be processing but the Macro hangs on Job_end.  The Macro is not running any quicker than when i had just the one job server.  Could my new Job server be picking up jobs and not completing them hence a timeout?

Steve.