Viewing 6 posts - 1 through 6 (of 6 total)
I created a SQL Task that does Select count(*) from Table, and then
use the Result Set tab to populate the package variable rowcount.
Put a 0 in the Result...
September 17, 2008 at 6:28 am
I basically create a ResaultSet variable from an exec SQL Task that is ordered by a field called location. I then have a ForEach loop that is used to...
August 12, 2008 at 10:10 am
I found an example like this yesterday and got this to work by using the Paramter Mapping tab and m,apping my variables to a paramter and referencing them with the...
August 7, 2008 at 8:13 am
It won't let me run this if the To section is blank within the Mail Tab of the Send mail Task. The examples I have seen show this fiewld being...
August 6, 2008 at 9:12 am
That's what I was trying to do, but when I ran the job, it kept saying that there was no recipient specified. I tested out my SQL to make...
August 6, 2008 at 9:04 am
The second operant field is giving me issues too.
How does the XML Task determine the number of rows returned and what is referenced in the procedent constraint in the Expression...
June 30, 2008 at 10:18 am
Viewing 6 posts - 1 through 6 (of 6 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy