I googled my way to here... so thought id update the trail for others....

SQL Server 2008 R2 SP2 is/was available from 26th of July 2012.

http://blogs.technet.com/b/dataplatforminsider/archive/2012/07/26/sql-server-2008-r2-sp2-now-available.aspx

I know it's always a good idea to provide examples. So here is my current test script.

edit: but looking at it I realise it's proabably a bit...

Thanks to all who replied.

This tale has a tragic end. well it would be the end.. if I wasn't still cleaning up. But as a warning (or amusement)...

Hi, thanks for your answer 🙂

Nadrek (8/16/2011)

---

The cleanest install is always starting with a fresh OS and working up from there. I like Windows Server 2008 R2, even as...

Wow, that is fantastic.

Thank you very much Craig.

Craig Farrell (2/16/2011)

---

As usual, when I start doing custom code, my disclaimer: Make sure you understand this before a production...

Craig Farrell (2/15/2011)

---

No problem. You'll find the Tally and/or Calendar table much quicker than...

Craig Farrell (2/15/2011)

---

The three standard ways to handle this with T-SQL would be the following:

- While Loop (slowest but most common)

- Calendar Table (requires upkeep)

- Tally Table ( requires understanding...

crazy4sql (1/26/2011)

---

there are 2 things which I would like to ask :-

1) Is your sql agent service running? go in services and check the account which is configured for...

Figured it out... Yay :satisfied:

For others struggling with this, i'll try and clarify. I don't know if I am using the correct terminology but i'll explain as best I can....

More info.

I've just tried using the built it accounts "Local system", "Local service" and "Network service" and they all fail with the same message.

I also tried using SA &...

umanpowered (5/7/2010)

---

...in Access 2003 during the linking process, there is a pop up box which asks the user to select Primary Keys before the Table link occurs. I was selecting...

.

The solution. (or at least our work-around.)

It seems that when we migrated the original schema from Oracle 9i to MSSQL using SSMA it created the tables with standard varchar field...

Well... I think...

I had the same problem and was given these suggestions:

http://www.sqlservercentral.com/Forums/Topic517984-148-1.aspx

The short answer is: there is no easy way to do this in SSIS. As in you can't...