question

I had created a Package which returns a result set which includes multiple rows having a data of a bigint type saved it in a Object type variable called TicketId inside execute sql task I created execute sql task attached it to for each loop container which will save the data from Execute sql task TicketId variable in singleTicket variable having datatype as Numeric My concern here is the datatype that are shown in the Variable window are different from the datatype shown in the Execute sql task window under for each loop (it will save ticket id it received from For each in a Table ) How Can I map both these two let say Variable windows shows datatype as Int16,Int32 where as execute sql task shows datatype as Numeric ,Long_Integar how can I map these both So when I create a New variable of type INT in SSIS Variable window what should be the Type in parameter mapping section of Execute sql task under for each loop container same for other data types