Viewing 15 posts - 7,921 through 7,935 (of 11,678 total)
OK, that won't work in a dataflow with an OLE DB Command, as the sp can probably return more than one line. Next time be a little more specific in...
February 16, 2012 at 12:06 am
You have the protectionlevel of your package probably set to EncryptSensitiveWithUserKey, which is the default. This makes sure only you can open and execute the package without losing sensitive data.
However,...
February 16, 2012 at 12:00 am
If you know a little bit about batch programming, than the file is pretty easy to write.
Here you can find the details about the DTEXEC utility, along with it's parameters:
February 15, 2012 at 11:56 pm
Henrico Bekker (2/15/2012)
throw in some SharePoint integration with Performance Point content as well....get ready to have your Reporting mind-set blown!
And while your at it, check out the new PowerView in...
February 15, 2012 at 11:49 pm
The OLE DB Command just fires the stored procedure against the database.
If you do not do anything with it, the data in the dataflow stays the same. Hence the one...
February 15, 2012 at 11:48 pm
Allright, I did the test.
* Created an Excel file in 2010. In the Save As window, there is no way to differentiate between 2007 and 2010, so my guess is...
February 15, 2012 at 3:05 pm
Jeff Moden (2/15/2012)
Are you really serious? You're generating a report with nearly 6 million lines of output? Who's going to read THAT?
Usually the business imports the results into...
February 15, 2012 at 2:59 pm
GSquared (2/15/2012)
Koen Verbeeck (2/15/2012)
Brandie Tarvin (2/15/2012)
Why does the sky change colors?
Sometimes it's pale blue, sometimes it's dark blue, sometimes it's black with little...
February 15, 2012 at 10:16 am
I have read your question a few times, but I still have no idea what you're asking.
What tools are you using? What are you exactly trying to accomplish?
edit: fixed typo
February 15, 2012 at 7:25 am
Brandie Tarvin (2/15/2012)
Why does the sky change colors?
Sometimes it's pale blue, sometimes it's dark blue, sometimes it's black with little lights, and sometimes...
February 15, 2012 at 7:16 am
Joy Smith San (2/15/2012)
Almost 3 days I was struggling with this. I hardly know Analysis Service. So I couldn't even look into the...
February 15, 2012 at 5:42 am
Joy Smith San (2/15/2012)
In visual studio, it...
February 15, 2012 at 4:41 am
Log in into SSAS using Management Studio. Right click on the server, select Properties and look at the security tab.
February 15, 2012 at 3:23 am
Viewing 15 posts - 7,921 through 7,935 (of 11,678 total)