Scenario:
Sometime we need to debug out SSIS Package but we do not want to insert records in destination but still we want to use all the transformations and dump these all records in some dummy destination. The goal can be to check the extraction performance from source OR view data at different points of Package but we do not want to insert data in destination at all. Which transformation can be used in SSIS as test destination transformation?Solution:
To do that we can use Multicast transformation as Test Destination. We do not have to connect any other transformation or Destination to Multicast. Here, the purpose of using Multicast Transformation is to just have test destination for Debugging.
How to use Multicast Transformation in SSIS Package as Test Destination |
OR
We can use Row Count Transformation. To use Row Count Transformation we have to create a variable first because Row Count always expect a variable where it can store the count.
How to use Row Count Transformation as Test Destination in SSIS Package |
You can watch the video for How to use different transformation in Data Flow Task just for test purpose so we don't have to write the data to any destination and only implement data viewer to see the data while debugging.
This was exactly what I was looking for. Thank you cania consulting for providing important facts test process improvement. Follow the link if you want to learn too!
ReplyDeleteMua vé tại Aivivu, tham khảo
ReplyDeleteve may bay di my gia re
vé máy bay từ los về việt nam
é bay từ nhật về việt nam
khi nào có chuyến bay từ đức về việt nam
vé máy bay từ Toronto về việt nam
đặt vé máy bay từ hàn quốc về việt nam
danh sách khách sạn cách ly đà nẵng
ve may bay chuyen gia nuoc ngoai
Welcome To Techbrothersit: Ssis - How To Use Test Destination (Multicast Or Rowcount) In Ssis Package >>>>> Download Now
ReplyDelete>>>>> Download Full
Welcome To Techbrothersit: Ssis - How To Use Test Destination (Multicast Or Rowcount) In Ssis Package >>>>> Download LINK
>>>>> Download Now
Welcome To Techbrothersit: Ssis - How To Use Test Destination (Multicast Or Rowcount) In Ssis Package >>>>> Download Full
>>>>> Download LINK Yl