I didn't realise that you might have multiple entries per row.

There might be a set based solution but I cannot think of it at present - something may come to...

I'm sure others would agree with me but don't use a cursor.

I would load the rows into a load table and then insert all of the 'D' values from the...

In Query Analyser, the results are limited, by default, to 256 characters.

Select Tools, Options.

In the Results Tab, change Maximum Characters per column to the required value.

Not sure about IIS.

J

Is this the only step in the DTS package?  If so, why not start the bat file using a specific step in a job using the Operating System Command (CmdExec)...

I think you are probably right in adding a new index with the columns in the order that I want.  The existing PK is clustered so the new index could...

Can you create the file E:\JOBS\Users.txt on your server and then the scheduled job?

J

Where does SQL Server itself reside?  The data is on your local machine in the E:\ - when SQL Agent runs the job it will run on the machine with...

As the execution plans were different between the sp and the native code, it is likely that the procedure was compiled some time ago and since then there has been...

You live and learn.

I used the table option because I was bulk loading from an external application (SAS) and I couldn't see any way from the external app to lock...

Have you considered setting the 'table lock on bulk load' option for the table? 

exec sp_tableoption <tablename>, 'table lock on bulk load', 'ON'

Have a look at BOL - it suggests...

Have a look at this:  http://www.sqldts.com/246.aspx

It might be as simple as setting the execution status of the current step to success:

Main = DTSTaskExecResult_Success

You have yours set to...

Can you supply the first few rows from the file and the ddl for the destination table?  Your BCp statement still references a .xls file - is this the original...

What does the ouptut from the stored proc look like in Query Analyser?  Is it a single result set of 3 rows or 3 result sets of a single row...

There is no built in functionality within SQL Server to achieve this.  You will have to build something yourself.

For example, you could write a function where you pass in the...

One way to ensure the sequence of rows, is to have an identity column on the load table.  You can order by this column which will ensure that the sequence...