srik.kotte (10/27/2011)

---

This is a bit senior position.I never worked on SSIS.I worked as a SQL Server Developer.I have knowledge on all tasks and transformations.I dont know if they ask me...

Great question, I didn't know this was the default.

Learned something on a Friday 😀

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.

Is it possible to post the actual errors?

Or do you just want us to guess 🙂

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.

naresh.elugala (10/26/2011)

---

Thanks for your reply.

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...

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.

That should be possible.

More info:

http://msdn.microsoft.com/en-us/library/bb326356.aspx

Interesting question, thanks.

Got it right by elimination, but as others have pointed out, there are for more efficient/elegant solutions for this problem.

Great question, thanks!

Great question, but I got it correct because I missed the line in the MSDN article about the default group 🙂

Great question, thanks!

Nice question, thanks.

Great question, but I got it wrong because I mistakenly read "without" as "with". :angry:

Me need more coffee!