I really appreciate the responding guys, but I don't think SQL Server 2000 can do the except.

Thanks

Tony

I need to run this for 15 columns. Folks keep posting this same checksum example with one column.

Hello,

Thanks for responding.

I need to compare two tables that are in existence. I saw this example of using Checksum after an update statement. I watched the video also.

But...

Scot,

I have a question about what you are asking. Are you doing this filtering of the columns for multiple rows?

In other words, the column that has a Y or...

Hello,

This can be easily done in a few ways.

One way is to begin your second package with a sql task that does a if exists to check for the existence...

Hello,

Are any of the packages using a multi-phase data pump in your SQL 2000 DTS designer? If so, a lot of code could have been written for various phases...

Hey Phil,

Have you ever checked for deadlocks?

Tony

Hello,

I just came across your post. This is fairly easy to do.

You can loop through directories to get file names to import or just give a variable a name...

OK...pretty simple.

These is a folder that has shared datasources. If in the properties you have Overwritedatasources set to false, it can't delete whatever folder you have designated in TargetDataSourcesFolder.

Either...

Thanks Ken

That worked! I knew it was something small that I was missiing. However, it was driving me crazy when I couldn't find the answer through the articles...

This looks interesting.

Thank you.

But I don't understand where you are getting 'comp' and 'table'. Are this variables?

Tony

Thanks guys.

I am learning so much from this forum! I like to research and investigate and come up with a strategy or a thought. Then I bounce it...

Gail,

On the messages tab, I got:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 79

The configuration option 'default trace enabled' does not exist, or it may be an advanced option.

...

Yes, Sir. SQL Server 2005.

Tony

Hello,

I found this query and ran it. It returned 0 rows.

SELECT * FROM ::fn_trace_getinfo(default)

Thanks.

Tony