It's the light-sabers, you're both using green on the left side. I get them mixed up all the...

Nope, they're soft faults.

Um, what forms are you running on your SQL 2008 database? Because unlike Access, SQL Server does not have a Forms system of its own, you have to use...

I assume that whatever process you have that is converting your "pre-normalized" table into these four tables is flawed. So you may want to include the information about that...

GROUP BY is the more general form of DISTINCT:

Select MAX(COL1) as COL1, COL2

From Table1

Group By COL2

Dude! Why does that Les Paul have stickers all over it, and those Fenders don't have a thing on them? Thats not right... 😛

Glad we could help. 🙂

Oh good, I was hoping Paul would take a look at this Ionut, he knows a lot more about this than I do. 🙂

Heh, yeah, thats for sure. 🙂

Try running this free utility from MS, on your server, it should tell you what's going on.

I thought that was if you tried to do it with WCF? But you could be right, WebServices through .Net is definitely not a strong area for me. 🙂

Heh, well some of us are slower than others. 😛

WayneS (1/20/2010)

---

Short of dynamically generating a batch file to run Robocopy (as in http://www.sqlservercentral.com/Forums/FindPost709542.aspx), is there any other way to use Robocopy in this SSIS package so that return codes...

Also, it's a good idea in SSIS to have one or more "Bad Row" output files, that you use in the DataFlow to divert such records to. Makes it...

The string's value probably is not a number. IE, "abc" cannot be converted...