Thanks, Chris. I'll get those fixed too.

As far as time... I'm a TechnoGeek. What TechnoGeek doesn't have time? After all, none of us on this forum has a social life,...

ACK!

I can't spell? THE HORROR!!!

Thanks, Andrew. I'll get that fixed. @=)

Your problem suddenly makes no sense to me.

If I understand, you have TableA which has an PK identity field. Then you have TableB where you're trying to take the TableA.PK...

Now my error is....

Files NOT Uploaded. Reason: System.Net.WebException: The remote server returned an error: (501) Syntax error in parameters or arguments.

at System.Net.WebClient.UploadFile(Uri address, String method, String fileName)

...

I'm trying to avoid hardcoding the IP address info or the file info in the script. Things change so often around my workplace, that it's easier for us to change...

Okay, I'm a dummy. I didn't look at page two of the link. So, I've corrected my code, but still getting an error.

Take the bolded from above and replace with...

How exactly are you planning on applying parallelism with this source table?

I see that you say you want 4 different Sources, but what will you be doing with these...

Are you trying to autogenerate a number during your insertion or pull the last identity field that was in that particular table?

These are two different tasks and require two different...

Depending on how busy I am, I do one of two things.

I either pick posts from the daily newsletter to respond to or I go into the forums directly (especially...

Rohit,

He already knows all that. He's trying to automate the copy process to a secured network drive and he refuses to listen to any of our advice on how to...

Andy Warren (12/29/2008)

---

Sorry, one more point - if you tag every post with a version, with a little work you can let users select which view they want - do...

I like the idea of compressing the forums down and having either a checkbox or dropdown list on the Thread Header / Title that asks for a version. This way...

I think I've fixed the line & title problem. Could you take a check?

I'll work on the image to the left when I have a breather (wrote 20-30k worth of...

Actually, it occurs to me to wonder if you have a link in some other table from UserID to UserName?

If UserName is not in any of the three tables...

I don't mean to offend anyone but...

Why does everyone insist on putting this check in the WHERE clause? It's messy and a Where clause usually complains when you try and...