Viewing 15 posts - 8,911 through 8,925 (of 11,677 total)
Please do not crosspost.
It wastes people's time and fragments replies.
Original post with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1197301-391-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 28, 2011 at 12:46 am
srik.kotte (10/27/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 28, 2011 at 12:33 am
Great question, I didn't know this was the default.
Learned something on a Friday 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 28, 2011 at 12:03 am
Another approach to avoid empty rows is to write a SQL statement to your Excel worksheet and use a WHERE clause with IS NOT NULL on a certain column.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 27, 2011 at 3:57 am
Is it possible to post the actual errors?
Or do you just want us to guess 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 27, 2011 at 3:52 am
Nice question, but answer number 4 was also incorrect, as both are of the geometry datatype.
A polygon can also be a geography datatype, but according to MSDN, Linestring is geometry.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 27, 2011 at 1:49 am
naresh.elugala (10/26/2011)
I am new to this scripts, never tried it. Can you suggest an example or a link which shows working with scripts, should be basic one...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 12:37 pm
You can easily check the number of files in a directory using .NET in a script task.
Use the GetFiles() method of the DirectoryInfo class.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 5:41 am
That should be possible.
More info:
http://msdn.microsoft.com/en-us/library/bb326356.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 5:33 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 1:41 am
Got it right by elimination, but as others have pointed out, there are for more efficient/elegant solutions for this problem.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 1:26 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 12:44 am
Great question, but I got it correct because I missed the line in the MSDN article about the default group 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 12:21 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 12:13 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 12:10 am
Viewing 15 posts - 8,911 through 8,925 (of 11,677 total)