Aggregate functions (like what Scott was proposing) would handle the NULL values. In other words - Max(column) will return the row with an actual value if every other row...

Did you have any luck determining the data error causing the DTS package to fail?

I know that would solve your e-mail issue, but then again - you wouldn't...

In general you only need to install the latest Service pack, since Service Packs are cumulative.

Microsoft Update is IMO the best place to get the latest Service pack (that's the...

Is some form of a self join not workable? You join the table to itself. In this case - one instance returns the sample, the other returns the...

Unless you have things like triggers in place to track when things are updated - no, there really isn't any built-in way to know when tables are updated (actually one...

Locking is available at all levels. TabLock, PagLock and RowLock.

Rowlock is on by default...

Are there any null values in either column? in the data you're trying to bring in?

Have you tried bringing the data in first into a staging table with no...

If you installed the Express Edition, you may need to go acquire SSMS from Microsoft's download site...

http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en

So - somewhere between row 7000 and row 8000 is some issue in the data (different format, something it doesn't expect, something violating the data types, etc...). You will...

Have you tried running the package by hand?

Also - the error is having an error itself, since there seems to be something wrong with the "helpdesk" e-mail recipient as well...

Model and tempDB don't have the same size. The starting size attribute doesn't carry over.

As of right now - my Model DB has a size of 1.19MB,...

You're not helping your cause by being so short on details....

That being said - depending on what you want to do, you could also use OSQL with an output file...

If there's a reason to store something in the system DB's - I'd put it in master (it's a reasonably common practice). Is there a specific reason you want...

It's not so much isnull as it is the fact that you're invoking functions in the join clause. Function used on indexed fields in the WHERE and ON clauses...

Correct - it's 1000 with SQL Server snapshot/transactional replication, 995 with Oracle snapshot replication, and 246 in a Merge Replication process.

http://msdn2.microsoft.com/en-us/library/ms143432.aspx