Thanks, Chiraq.

That works. It appears that you cannot delete dumps from 2000 sql for some reason using xp_delete_file.

I tried that and it did not work.

In fact, I cannot even delete the files by pointing directly at the subfolder with the older files in it now.

What you have to remember is that dts treats csv files different from excel files.

If you have a numeric destination column and the entry is null in excel, it will...

Make sure that the tables contain the same headings on all of the spreadsheets. If not, this exact error will occur.

Make sure also, that there are no links to other...

Wrong name. DTs has changed now to SSIS.

You must select create a new "Integration Services Project". You have to include this on the install on your client.

What you are talkin about here is a basic datawarehousing technique. This is what you should do:

1. Create a table that matches the target table. We will call this a...

Basically you need to loop through the information.schema tables and get the tables and columns. You can execute select statements on those.

Rather than rewriting, this link will do you.

You have to donwload and install the excel add in for AS25K.

http://www.microsoft.com/downloads/details.aspx?familyid=BA53E05D-1C5F-4B44-A76C-3DEF3F707038&displaylang=en

This excellent article will show you all the methods including passing values to global variables in a package.

http://www.sqldts.com/?208,1

Be careful when using the wizard. It uses an encrypted ID that can change if the package is amended (IE - becomes a new package).

Best way is to use the...

Select ARDoc.OrdNbr from ARDoc

left outer join Shippers

on ARDoc.OrdNbr = Shippers.OrdNbr

where Shippers.InvcNbr ARDoc.RefNbr

This article will help you troubleshoot your problem:

http://www.databasejournal.com/features/mssql/article.php/3372131

There is now way to do this as far as I know.

However, in a round about way there is.

If you use 'sp_helpdb', you will get back all the database names...

Apologies, David. Should have clarified a bit better.

Excel has an internal pointer that dts picks up on as the end of the spreadsheet. I forget what it is called.

But if...

Try using 'collate database_default'.

CREATE VIEW dbo.YYYY

AS

SELECT *

FROM ZZZZ.Part.dbo.XXXX XXX_1 collate database_default