i have a package with 3 Execute sql tasks, 1 script task and 1 send email task. i have three tables a, b and c.
1st execute sql task counts the no of records from table a, puts the result in variable cnt and it has an expression @cnt > 0, 2nd execute sql task counts the no of records from b, puts result in cnt2 and it has an expression @cnt2 > 0. 3rd
execute sql task selects the fields from table c. Table c has only two records and two columns, e.g column1-->TableName( a, b), column2-->(http://a,
Now, i wanna write down script in script task such a way that when table a and b would have records send an email with column1(table name) in subject and column2(weblink) in message of the email and if table a has no records then only table name b in subject
and weblink http://b in message and viceversa.
NOTE : if i do this for one record from table c then it works but then i have to have same two tasks for two records and send two emails. but i am thinking to do this in only one task.
Appreciate any help
View Complete Post