Thanks for telling me, William, but the problem doesn't appear to be my website. It looks like the hosting server is down.

I'm going to call tech support shortly if...

Yes.

Actually, I like the adjustable display idea too.

But it does seem like an awful lot of code to rewrite in order to get it working to begin with.

The Execute SQL Task takes in a parameter in the stored procedure.

Goto Parameter Mapping on the left side menu. Enter in the variable name and call it 0 in the...

Okay, here's what we've got.

For-Each Loop with an ADO Enumerator. The configuration is set to an Object variable (as you said) with the mode as Rows in the First Table....

Aha! That's the detail that was missing. @=)

Give me a few. I think we have a package that does something similar, but we use a WebService, so I'm not...

Wow. I'm going to fill up this thread will all of my own replies.. @=)

I just figured something out.

Error:

Files NOT Uploaded. Reason: System.Net.WebException: The remote server returned an error:...

Okay, I've tried 3 or 4 different ways of scripting this out and now it always comes down to the same error:

Reason: System.Net.WebException: The remote server returned an error: (501)...

afgone,

I still don't understand why you need to do all this fancy work for one field.

If you're just trying to change the data type of this field, use a Derived...

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...