Viewing 15 posts - 8,521 through 8,535 (of 9,720 total)
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.
December 31, 2008 at 12:51 pm
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...
December 31, 2008 at 8:42 am
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....
December 31, 2008 at 8:07 am
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...
December 31, 2008 at 8:02 am
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:...
December 31, 2008 at 6:49 am
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)...
December 31, 2008 at 6:13 am
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...
December 31, 2008 at 5:33 am
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,...
December 31, 2008 at 5:28 am
ACK!
I can't spell? THE HORROR!!!
Thanks, Andrew. I'll get that fixed. @=)
December 31, 2008 at 4:40 am
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...
December 31, 2008 at 4:38 am
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)
...
December 31, 2008 at 4:32 am
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...
December 31, 2008 at 4:07 am
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...
December 30, 2008 at 12:00 pm
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...
December 30, 2008 at 11:42 am
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...
December 30, 2008 at 11:37 am
Viewing 15 posts - 8,521 through 8,535 (of 9,720 total)