Viewing 15 posts - 4,756 through 4,770 (of 11,676 total)
I usually assume a basic understanding of SQL.
I'm not going to put a comment like "and now we insert the data into the dimension".
I explain the business logic used in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 1:44 am
These components are usually used in Data Quality projects.
For example, the Fuzzy Lookup can be used to match "Belgium" with "België", something the regular Lookup component can't.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 1:41 am
The official manual or documentation is Books Online.
You can get there by pressing F1 and filtering on Integration Services.
Another option is to buy a good book, such as this one:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 1:40 am
Is the warning still there when you close the project and re-open it?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 1:37 am
Do the installation logs give any more info?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 1:36 am
You can also connect Visual Studio to the project on the server.
Choose File,Open from the menu and choose Analysis Services Database.
This online editing mode has however a certain amount of...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 1:35 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 12:55 am
Your question is not entirely clear.
Can you post some sample data and desired output?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 12:43 pm
Eliza (9/25/2013)
Koen Verbeeck (9/25/2013)
Maybe you can put the name and the subreport in a table?Hi,
The name and subreport are in a tablix deatil row if this is what you mean?
Thanks
Eliza
Yes....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 12:26 pm
Marc M-454371 (9/25/2013)
Does it make sense that I would want to "XXXXXX" out the value stored in the packages (either in variable...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 12:25 pm
Marc M-454371 (9/25/2013)
I agree with your approach but I am starting to get a bit confused as to what my best set up should be.
My...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 7:52 am
Jeff Atherton (9/25/2013)
Koen Verbeeck (9/24/2013)
Some point totals have special statuses that only people who know a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 7:43 am
EncryptSensitiveWithUserkey is a disaster waiting to happen, as sensitive data can only be de-encrypted when you open the package.
Unless you are going to run the package on production every time...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 7:41 am
Maybe you can put the name and the subreport in a table?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 5:58 am
Concatenating Row Values in Transact-SQL[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 4:47 am
Viewing 15 posts - 4,756 through 4,770 (of 11,676 total)