SCD allow to use SQL - by Katie and Emil

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 778657 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/6/2013 7:06:44 AM
Access Restriction Public

Description

Hi

SCD can be really quick if both input rows and dimension have the same sorting (business key), however that currently requires clustered index on dimension that would use business key. Would you consider either:
1) Adding option to provide T-SQL (so I can use index hint)
2) Provide two inputs for SCD: 
-- input rows 
-- dimension rows

Take care
Emil
Sign in to post a comment.
Posted by Microsoft on 4/2/2014 at 7:57 PM
Hello
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SSIS. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available.

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.

Mariusz Cichomski
Program Manager
Microsoft
Posted by Microsoft on 5/23/2013 at 1:06 PM
Hello Katie and Emil. We’ve looked into this item. While it will not be addressed in the current release cycle, we have added it to a list for consideration for the next. Thank you for the feedback. We will keep track of the suggestion. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)