Sean Lange (1/14/2015)

---

Charles Kincaid (1/14/2015)

---

Great QOD Steve. I would have not thought that this would have that many issues.

Seems that COUNT() does some fun things. I have been...

Action figures will soon be available! 😎

Do not use a linked server but rather use a data flow where you directly connect to DB2.

Run as much as you can in parallel.

Try Microsoft Virtual Academy:

http://www.microsoftvirtualacademy.com/training-courses/implementing-data-models-reports-with-microsoft-sql-server

You need to use the ADO.NET connection manager instead of the ODBC connection manager (yeah, obvious right? :-D)

In the ADO.NET connection manager you can select the ".NET providers\ODBC Data provider"...

Lempster (1/14/2015)

---

Koen Verbeeck (1/13/2015)

---

You're right. It will scan only 16,483 rows, as mentioned in this KB article. I have no idea how I got that 60,000 number in my head....

Nice but somewhat easy question (especially after the quite lengthy discussion of NULLs and aggregates last week). Not sure it is worth 2 points.

Brandie Tarvin (1/14/2015)

---

Koen Verbeeck (1/13/2015)

---

I tested it and the numeric value is...

Lempster (1/14/2015)

---

Going back to the checksum idea, you might want to 'roll your own' by using a HASH such as MD5 or SHA1 because you'll get fewer hash collisions (false...

Thank you for your kind words :blush:

I tested it and the numeric value is imported as well, but...

ps_vbdev (1/13/2015)

---

Koen Verbeeck (1/13/2015)

---

ps_vbdev (1/13/2015)

---

Ok so your doing the comparison in your staging area. but you would still have to do a full extract from source db (bulk Insert?) to...

FYI, I received the Author of the Year award at MSSQLTips.com!

Thanks everyone for voting!

Jimmy123 (1/13/2015)

---

At SSIS at 2008, it will only scan 16483 records max with typeguessrows set to 0 as Microsoft have capped it at this. This is a common misconception even...

Moving the databases is indeed an option.

Migrating SQL Reporting Services to a new server by moving the Reporting Services databases[/url]

Be aware of the encryption.