Hi Guru;s I am getting error diring declaration in the script task. Below is the declaration Dim dterpt_start_date As Int32 = Convert.ToInt32(Dts.Variables("User::rpt_start_date").Value.ToString())

what is the datatype of the ssis variable?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

and are you sure that error is related to this line of code? did you tried to put breakpoint and find error line?http://www.rad.pasfu.com

Hi, It is the datetime date type and I got it resolved when I changed int 32 to datetime. THanks !!! Roy