question

Bhupendra99 avatar image
Bhupendra99 asked

Diffrences in Datatype in SSIS Variable window and its components datatype

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
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.