no no i dint mention it.... what im saying is if you set result set to single row means then by default the query have to return a value. if...

if it returns null value means the following error will occur in the execute sql task 1 and if you set precedence constsint as success means then the second execute...

hi maria,

i need a clarification.. in the result set if the procedure returns a null value means then it will show an error. you don need to use constraint itself..how...

i did the same.. but the same error.. wat i have to do now..

thanks in advance

hi,

hearty thanks for your reply...

if i disable that script task and schedule means the package is running smoothly. if i enable that task then it is showing the above said...

hi azhar,

im also facing the same problem. can u explain me in detail how to do this.

thanks in advance

hi,

thanks for your help..

i found one more solution also.. by giving the maximum error count value to a large value we can do the same thing

hi,

first of all sorry.. im not coming here to answer your question.. my problem is i cannot send mail through send mail task.. i think you are sending mail through...

hi,

the log table has only one column. actually im using this execute task in event handler.

when i modify the insert statement such that only one ? is present then ...

hi jack,

it is showing the following error.

[Execute SQL Task] Error: Executing the query "INSERT INTO [log] ...

is it your source of data an excel sheet???????????

if yes means you can change in the open row set as (sheetname$)A6:MM6000

hi,

that link was awesome..

thanks everyone for helping me out..

hi,

for this the solution is...

go to connection manager-->properties-->expression-->connectionstring-->and then change the value of HDR to NO