Viewing 15 posts - 8,401 through 8,415 (of 11,678 total)
SKYBVI (12/21/2011)
And one with pretty pictures:
This really helped me..
Thanks a lot koen
Regards,
Skybvi
No problem, glad to help.
December 21, 2011 at 11:17 pm
If you do not have implemented package configurations, your SSIS package will still use the values...
December 21, 2011 at 11:11 pm
GilaMonster (12/21/2011)
Koen Verbeeck (12/21/2011)
December 21, 2011 at 7:51 am
arun1_m1 (12/21/2011)
As I understand from your query , you want to create a SSAS cube from the excel data. If I am correct then the below link should...
December 21, 2011 at 7:50 am
The parameter mapping is to put parameters into the SQL statement.
What you need is the result set:
http://msdn.microsoft.com/en-us/library/ms141689.aspx
And one with pretty pictures:
December 21, 2011 at 7:16 am
mic.con87 (12/21/2011)
I have two related questions
1)Can I assume dropping tables will free memory as I proceed with the query? After #table_2 is created drop #table_1 etc
2)After...
December 21, 2011 at 7:05 am
tt-615680 (12/21/2011)
Koen Verbeeck (12/16/2011)
Are you trying to connect to SSAS from an Excel sheet, or are you trying to connect from SSAS to an Excel file?
Thank you for your response!
I'm...
December 21, 2011 at 6:43 am
Allright, I asked some of the guru's on the thread, and Gail said that this one is indeed terrible (and I do trust Gail).
Actually, this is the predecessor of an...
December 21, 2011 at 2:55 am
Phil Parkin (12/21/2011)
But it will continue to cause confusion, and, for some, I suspect, annoyance.
Tsk tsk tsk, Hall Of Fame, is that the christmas spirit? 😀
December 21, 2011 at 2:31 am
engrshafiq4 (12/20/2011)
i am asking SSC Eights!
He correct my code in his above post.and that worked for me.
Let me explain the issue
consider i have a table
CREATE TABLE [dbo].[Cities](
[CITY]...
December 21, 2011 at 2:30 am
thtsps (12/21/2011)
Thank you koen,One thing, I'm not sure for 2005 which one about control flow item?
-For Loop Container
-Foreach Loop Container
Please advice. Thanks in advance
The second one. Do something for...
December 21, 2011 at 2:24 am
Can anyone of the DBA guru's (I'm certainly not one) take a look at this thread:
http://www.sqlservercentral.com/Forums/Topic1224893-391-1.aspx
It's about SharePoint databases administration. I suggested the OP - Divine Flame - that there...
December 21, 2011 at 1:36 am
Divine Flame (12/21/2011)
Koen Verbeeck (12/21/2011)
a few years ago, the SharePoint team published a white paper with "advice" on how to administer those databases. It was full of...
December 21, 2011 at 1:32 am
falcon00 (12/20/2011)
Please explain what configurations should be adjusted so that the package will no longer point to my local machine.
How should we knkow which configurations to adjust, if you...
December 21, 2011 at 1:25 am
That won't be (easily) possible with SSIS. SSIS just dumps the data in the Excel file.
Maybe if you create an empty sheet with the dropdown already present and SSIS just...
December 21, 2011 at 1:23 am
Viewing 15 posts - 8,401 through 8,415 (of 11,678 total)