1
vote
1answer
94 views

debugging an ssis package which is invoked from a .net application?

can we attach a debugger to an SSIS package which is invoked to execute from a .net assembly?
4
votes
2answers
394 views

Using surrogate key after merging the person's data?

This question is about business intelligence with sql server 2008 R2. If you have a person named Jim Brown with his birthdate and social security number (SSN) being located in three different source ...
0
votes
1answer
155 views

Recommended Data profiling tool for BI developer

What recommended data profiling tool to retrieve a lot of information and enable to visulize the data into graphical statistics? The data is coming from the source database.