hxkresl (1/3/2011)

---

Looking at Advanced Editor/Input and Output Columns for the flat file: The external source is a flat file (.csv) and output destination is SQL Server table. The external and...

I think the most important questions for the initial interview are:

* where is the file located?

* can the location change over time?

* what are the columns and what data is...

Do you have dimension security or are you using NONEMPTY?

If yes, read the following KB article:

http://support.microsoft.com/kb/940019

Be aware that the Sort component is a blocking component in SSIS and that it can drastically affect performance if you transfer a lot of rows. If this becomes an...

Oh yeah, a tip for the author:

if you really want to deceive people, you should've included the number of rows that had a 3 in the answer. Eight rows I...

Jeff Moden (1/3/2011)

---

Brandie Tarvin (1/3/2011)

---

Quick question for those on LinkedIn. I just received a message over the past two days (two messages actually) asking for advice on performance tuning tools....

sathishmcc (1/4/2011)

---

Im getting the error while running the query

Server: Msg 8101, Level 16, State 1, Line 7

An explicit value for the identity column in table '@student' can only be specified...

What's...

With all those goals, I'm even surprised...

Good question, but with lots of trickery.

What point were you trying to make? Duplicates with UNION, TRUNCATE in transaction or columns referenced directly in the IN clause?

Glad...

No problem at all. If you have more questions, do not hesitate.

With fireworks? 😀

Craig Farrell (1/3/2011)

---

For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have dealed with that issue.

Happy...

Nice concept. I'll add my bit.

Goals for 2010:

Professional

* Get certified. Well achieved: 1 cognos certificate and the 3 MCTS certifications for SQL Server

* Events: attended MS Tech Days and SQLServerDay...