Viewing 15 posts - 7,861 through 7,875 (of 11,676 total)
Damn you MSDN!
Any documentation that supports the correct answer?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:32 am
Martin Schoombee (2/21/2012)
Your other option could be to use the "ForEach" component to loop through all the files in a folder, and deal with them appropriately.
The For Each Loop is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:27 am
Peter Newman-311337 (2/22/2012)
I understood the example Any gave, but what i dont follow and needed an example of is where he says
'If you want to do this for values based...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:22 am
paulbw (2/21/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:19 am
Peter Newman-311337 (2/21/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:07 am
Upgrade to a higher edition (standard/developer/evaluation/...).
SSIS is not supported in Express.
Features Supported by the Editions of SQL Server 2008 R2
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:05 am
Sander Stuurwold-385722 (2/21/2012)
isn't it the case that excel is full? (64000 rows exceeded?)
Remember that the latest post in this thread is already a few months old.
Furthermore, Excel is nowhere mentioned...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:03 am
Set up 3 different dataflows with each it's own Excel destination and it's own Excel connection manager. Make sure you select 2007 in the connection manager to have the .xlsx...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 11:59 pm
sestell1 (2/21/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 7:52 am
Congrats Winston!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 6:21 am
Tee.M (2/21/2012)
OLE DB provider "MSDAORA" for linked server "CDIHWHPROD2_EIW" returned message "ORA-12154: TNS:could not resolve the connect identifier specified
".
Msg...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 6:13 am
Charmer (2/21/2012)
i agree with you , that we have an option to redirect it...but what if we created a package and working on the production server...? i mean i...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 5:40 am
oskaroh (2/21/2012)
maybe SSIS is not ready (or able) to manage complex windows...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 5:38 am
Charmer (2/21/2012)
Phil Parkin (2/21/2012)
Charmer (2/21/2012)
If Ignore Failure does not work exactly....then why should we have a such condition...or when will it work if we do Ignore Failure..?Please reread Koen's response.
Hi...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 5:20 am
I doubt it, as SSMS and Visual Studio don't use IE to browse the data.
You can try connecting with Excel to the SSAS cube and see if you can create...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 21, 2012 at 5:00 am
Viewing 15 posts - 7,861 through 7,875 (of 11,676 total)