Viewing 15 posts - 8,536 through 8,550 (of 11,676 total)
luissantos (12/13/2011)
I have on my laptop SQL Server 2008 for Workgroup and i want to install the new SQL Server 2008 R2.
What you suggest to do, remove the previous...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 11:32 pm
ptejasree (12/13/2011)
can someone help with the code in c# for the above scenario
What do you have so far?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 11:13 pm
Evil Kraig F (12/13/2011)
Koen Verbeeck (12/13/2011)
However, if you select a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 2:06 pm
It is the only way.
You redirect all the rows that generate an error to an output. Include the ErrorCode and the ErrorColumn with it and with some scripting, also the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 6:54 am
But you will be developing the package itself, right?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 6:26 am
Charmer (12/13/2011)
Koen Verbeeck (12/13/2011)
Read this article, it has pictures, maybe that helps.
i understood that you fell sick of me...that's why you mentioned like "it has pictures"...sorry buddy...i have been telling...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 6:20 am
Read this article, it has pictures, maybe that helps.
http://msdn.microsoft.com/en-us/library/ms141679.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 5:53 am
ptejasree (12/13/2011)
Thanks for the reply. But in my scenario I have to take the string values between "="
and break them into 7 levels.
So for which option I should go, Substringmethod,IdexOf...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 5:42 am
Create a table, flat file, whatever you want.
Put error handling on the component that you want to monitor. Create a destination for your table, flat file whatever. Draw a red...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 5:30 am
Substring:
http://msdn.microsoft.com/en-us/library/aka44szs.aspx
IndexOf:
http://msdn.microsoft.com/en-us/library/5xkyx09y.aspx
Trim:
http://msdn.microsoft.com/en-us/library/t97s7bs3.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 5:12 am
Charmer (12/13/2011)
i know how to get the error rows inside the package ......
so i need rows too....
Euh. Problem solved?
That's the point of custom logging. If you handle the logging yourself,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 5:03 am
lkokeunda (12/10/2011)
In the face of upcoming inevitable advent of the new version of the product, would you suspend your SQL sever 2008 cert prep...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 4:53 am
ptejasree (12/13/2011)
i'am new to c# script can you tell me how to code my above scenario in the script component
Have you read the article that I provided you in my...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 4:49 am
Charmer (12/13/2011)
i am able to get the error columns as well as tables..but not able to get the exact error records...is this possible to get the records..?
What do you mean...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 4:40 am
arkiboys (12/13/2011)
Fixed the problem.It seems all the parameters have to be on one single line.
Thanks for your time.
If that doesn't make you bang your head against the wall, what doesn't?...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 4:00 am
Viewing 15 posts - 8,536 through 8,550 (of 11,676 total)