The SSIS dataflow can't handle changing metadata, so the number of columns should be fixed.

Ergo, you should know this number upfront.

Too easy 😀

k.subramanyam1017 (5/21/2012)

---

I think each and every single database contain 1 datafile(mdf file) and 1 log file. is it correct or not pls give me answer.

1)how to find out the...

I learned yesterday that my session about columnstore indexes on the Belgian community day is only 45 minutes. That's gonna...

vinu512 (5/21/2012)

---

pdanes (5/21/2012)

---

Oh? I didn't know that, and I seem to remember reading that multiple...

Well, the answer of question 3 is simple:

the first one installs SQL Server 2005, the second one installs SQL Server 2008.

Regarding the other questions:

they are asked to determine what DBA...

According to BOL, an IN clause is the same as the different elements with OR constraints.

SELECT ...

WHERE column IN ('a','b','c')

equals to

SELECT ...

WHERE column = 'a' OR column = 'b'...

Nice question, thanks.

Nice question, thanks.

Lynn is right. You need to open the advanced editor of the source component and set the IsSorted property to TRUE. Then you have to indicate which columns have been...

MisLead (5/16/2012)

---

Lynn,

Actually I need to...

I tried it and I can import the data just fine. The "line breaks" from the Excel file are shown as squares, indicating that they are special characters. You can...

Great article, food for thought.

michael vessey (5/16/2012)

---

MisLead (5/15/2012)

---

Does anybody no sql command in ADO.NET connection support "order by " clause or if there is a work around for it. I am trying to...

Are you using an Execute SQL Task?

You should be able to use the ORDER BY clause just in your SQL statement.