Viewing 15 posts - 3,031 through 3,045 (of 11,677 total)
It is an Excel add-in and is part of the Power BI offering of Microsoft.
That means the data is read into Excel, which you'd have to read in with SSIS.
You...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2014 at 2:15 am
I know Power Query can handle JSON pretty easily.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2014 at 1:03 am
How are you calling the stored procedure?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2014 at 12:35 am
That's insane rambling and extremely short-sighted.
We're 9 years further than 2005, and ETL jobs are still as important.
Just using views as an intermediate layer between the transactional system is not...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2014 at 12:28 am
I don't think much has changed.
You're still stuck with 3rd party tools.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2014 at 12:23 am
Am I the only one who thought the question was worded a bit strange?
However you would not like to get the results back in a grid
Anyway, as stated above, the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2014 at 12:19 am
J M-314995 (5/15/2014)
Right now I'm using SSMS but when I get everything put together, I'm going to throw the script into an SSIS package and put it on a schedule.
If...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 11:52 pm
mister.magoo (5/15/2014)
Try copying the first data row down so all the rows have exactly the same data - does it fail then also?
Or copy the contents into a brand new...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 11:50 pm
In mathematical theory, a tuple (which is what we call a row, and a table is a relation btw) consists of ordered elements.
However, if you say element, no one will...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 12:43 pm
How are you bulk loading?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 12:36 pm
No errors/warnings?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 12:36 pm
gbritton1 (5/15/2014)
There is a CountRows function that you can use. If it returns 0 for your dataset, display the No Rows Found message.
I've done something similar recently.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 12:33 pm
Steve Jones - SSC Editor (5/15/2014)
skeleton567 (5/15/2014)
Koen Verbeeck (5/15/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 12:28 pm
Ian Massi (5/15/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 7:27 am
david.wright-948385 (5/15/2014)
skeleton567 (5/15/2014)
This is exactly why I oppose the development of computer controlled vehicles.
I'm kinda hoping that the software controlling automatic cars will fall under similar standards as airplane...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 15, 2014 at 7:09 am
Viewing 15 posts - 3,031 through 3,045 (of 11,677 total)