Yes, I'm administrator and so is the account that's executing the job.

For every executable statement, dynamic or not, I'm capturing @@ERROR into a variable.  The drop index sproc sends this...

Eventually had to go with ye olde "INSERT INTO... SELECT FROM" with "ALTER DATABASE <name> SET RECOVERY BULK_LOGGED" instead of BULK INSERT with a format file.

It works but's probably slower than...

This is annoying.  You'd think that if I tell it to start reading on row 2 it would ignore row 1 altogether.  Who cares if there aren't spaces around the...

I need the format file to slightly transform the data.  And since these files are GBs I can't really use a staging table.

Argh... BCP does the same thing.

Yes, it ends in 0D0A.

If I add a space on either side of the comma in the header row, it works.  I won't be able to modify the text files coming in though.

Is there...

Yes.  It had a bunch of extra spaces after the last column header name, but I even removed those and put in a carriage return of my own.

This is very...

In the data rows, there are spaces surrounding the commas.  The header row using commas as the delimiter but has no spaces.

My format file looks like this:

8.0

28

1 SQLCHAR 0 0 " , " 1 Ban SQL_Latin1_General_CP1_CI_AS

2 SQLCHAR 0 0 " , " 2 subscriber_number SQL_Latin1_General_CP1_CI_AS

3 SQLCHAR 0 0 "...

Yes, and I get the following error:

Server: Msg 4864, Level 16, State 1, Line 1

Bulk insert data conversion error (type mismatch) for row 1, column 1 (Ban).

It tries to read...

That makes sense.

I think I'll convert the NCIs on the call-date and subscriber-number into a composite CI on call-date, subscriber-number.  And since the data is read-only (and the indexes are...

Unfortunately, there's nothing that uniquely identifies the rows within the current data which is why I was thinking of adding a PK/CI.  It's phone-call data: so originally I was thinking...

Hmmm....

Well, I can't really change the owner of the jobs from dbo and giving the users who need to run these jobs sysadmin isn't an option either. I don't...