Compassion

???

From what I have read SSIS 2008 packages can not be run using SSIS 2005.

Jeff,

Wouldn't a million row setup show what you are talking about? Of course, you could make it ten million.

I have to agree with Jack, Bob. Thank you taking that initiative to check on Barry. It definitely sets SSC apart from the rest! This is the...

Is it just me or has Barry gone missing??

You need to connect to Integration Services on the server.

Just to be sure, is rowid unique?

You should be able to script your database for SQL Server 2005 to recreate the database structure in a SQL Server 2005 database and then use export data to transfer...

SQL Express is free, but if you want to experiment with all the features of SQL Server you can purchase SQL Server 2008 Developers Edition for about $50.00 USD. ...

Looks like you want the last day of the current month, correct? If so, try this:

select dateadd(mm, datediff(mm, 0, getdate()) + 1, -1)

It also depends on how many duplicate records vs uniqie records you have in the table. How many unique rows (based on email) are there in the table?

If I may, you may wish to start by reading about RESTORE DATABASE and RESTORE LOG in BOL (Books Online, the SQL Server Help System that you may access directly...

I guess it depends how random the random numbers really are in this case. Would probably need to see if there is a way to capture the distribution. ...

Nice bit of work there bitbucket. I'd have expected more duplicates in the shorter string with it only being six characters long.

What is the source of the data? Instead of a comma delimited file, could you get a pipe delimited file?