SSIS Script Component/Task are no rocket science. All you need is your basic logic and requirement of the component behaviour clear.

A WMI Query can also be used for the same

😎

But again I would re-iterate what other posters have said..."read and practice":-)

Hapy to help.

Hi Alina,

Please click here

Though MDX will give you better flexibility rather than implementing multiple joins using the T-SQL.

Please google the same as many a times you would find the posters using the acronyms instead of the entire name. Hint (FEL=For Each Loop).

Also, this is not an...

Hi,

SSRS does provide such dynamic columns associating but if time is constraint I would suggest using a Pivot Transformation in your underlying SQL query and populate it on SSRS reports,...

The statement will only return you a count of rows...create a variable having a...

Approach 1: Entirely handle the value increment using a Script Task

OR

Approach 2: Design package using FEL->ST->DFT/EST

That is why we have surrogate keys...:-)

lol...

You have great gift of self learning. Please google the same.:-)

Implement a Pivot transformation either using SSIS or in T-SQL.:-)

Simple Answer. Not possible is SSRS.

You may consider the MDM using a CDC, as it elimintaed the minimum batch size window.

Click here for more details.

And as suggested by da-zero, a data staging platform can make...