Viewing 15 posts - 7,246 through 7,260 (of 11,676 total)
Error messages with an ID greater than 50000 are user-defined error messages.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 25, 2012 at 1:32 am
Welsh Corgi (4/24/2012)
I click on debug and nothing...
It's probably validating everything again 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2012 at 2:04 pm
asranantha (4/24/2012)
i want to write Msbi (ssis,ssrs,ssas) certification.plz ...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2012 at 1:58 pm
Lynn Pettis (4/24/2012)
jcrawf02 (4/24/2012)
Who killed JR again?Personally, I scheduled my college classes around "Whose Line Is It Anyway?"
I didn't know JR was killed? I thought he was just...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2012 at 1:11 pm
Put a rowcount component on the error redirection.
If the count > 0, take some action right after the dataflow. (use an expression on the precedence constraint)
E.g. delete the file, delete...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2012 at 6:47 am
sqlmunkee (4/24/2012)
So, the key bit here is that SQL will *decide* whether the sequence is ascending or descending based on the INCREMENT BY argument.
That only seems logical to me.
If the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2012 at 5:36 am
1. Use a Lookup and keep only the match output.
2. Use again a Lookup and retrieve the name and country columns. The match output is routed to an OLE DB...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 11:50 pm
RamSteve (4/23/2012)
My Question is i need to load the data from one table to my destination table regularly and i need only to add the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 11:45 pm
You need to install the Oracle client and configure it.
Make sure either the Microsoft OLE DB provider for Oracle or the Oracle OLE DB provider are installed. If you have...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 11:43 pm
Did you add yourself as one of the admins during the set-up?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 11:31 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 11:15 pm
opc.three (4/23/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 12:54 pm
Gerbera (4/23/2012)
Yes Koen.. I will use 1252 instead of Unicode.just curious to know, if there is any specific code page related to mainframes..
No idea. I don't know a lot about...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 4:01 am
Try using 1252 codepage, which is the default.
In order to do that, you can't use Unicode anymore.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 3:55 am
Lynn Pettis (4/23/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 12:15 am
Viewing 15 posts - 7,246 through 7,260 (of 11,676 total)