It's beginning to look like a permission problem to me.

When it runs interactively it runs under whatever nt account you are loggied in as.

When it runs scheduled, it runs under whatever...

In that case you may be looking at insufficient disk space either for the database or the log.

If the process ran when started manually you can rule out bad data...

If you only want to send a mail why use the asp page as a middle man.

Just use something like xp_sendmail. See BOL for info.

declare @myval as varchar(100)

set @myval = 'CONX 6288-4'

select Left(@myval,charindex (' ',@myval,1)-1)

Are you trying to export from dts or import into it?

Makes a difference to know.

Let us know if you do find out. Just a thought, but perhaps the columns in the db are char and it's padding out the output from sql server but...

Look to see if any jobs were running around the same time last night that could have affected the running of the package. Eg database set to read only..

Have you tried adding another step in activex code that just opens and saves the spreadsheet again at the end and see if that makes any difference. Try using the...

Check that:

a - all the small int values are integer values

b - the small int values are small enough for that data type

I reckon that the original file you created was longer than the file you have now and excel is keeping the empty rows at the bottom and columns at the...

There is nothing wrong with your query. Have a look to see what data type the column is and post back. May be that you have it as a text...

You are describing a typical data warehouse task.

The right and proper thing to do is:

Create a staging table with the relevane columns required for import ONLY.

Truncate the staging table.

Take the...

You may be able to if you are using sql server 2005, but very doubtful with 2000. Was never really written to produce or work with xml other than bog...

a tnsnames.ora file is a text file that contains information such as server name, database name, username, passowrd etc that you need in order to connect to oracle to run...

Have you checked that the Distributed Transaction Coordinator is started on the server itself?