thanks i'll try parameter mapping

hi

im store the resault from :"select max()..."

by : single row

ist not ok?

the error say that variable is empty?!

hi i see the problem:

at sql task query i used select and assign the reaulto first variable but is not set i dont know why

Error: The type of the value (Empty) being assigned to variable "User::weekCode" differs from the current variable type (Int32). Variables may not change type during execution. Variable types are strict,...