The...

Smash125 (10/25/2013)

---

Thanks guys all your input. Tuning of query is given to me in the morning, i have no idea about the query and database involved. Thank fully i went...

Also want to note here that the ORDER BY clauses are pretty useless if you want to join results together.

It will only read the flat file with the name configured in the flat file connection manager.

Since all files in a folder have unique names, you read only 1 file.

In...

chandan_jha18 (10/25/2013)

---

Koen Verbeeck (10/25/2013)

---

It might depend on indexes, the physical location of the rows in the pages and how the query plan is generated.

Let's assume it's "random" unless you specify...

Please read the first link on my signature about how to post questions.

If you want people to even try to solve your issue, please post table DDL, sample data and...

Colleagues of mine did a DWH project with Chinese data mixed with English once, and I believe they just used unicode everywhere, but I'm not 100% sure.

It might depend on indexes, the physical location of the rows in the pages and how the query plan is generated.

Let's assume it's "random" unless you specify another column in...

Also set the recovery model to simple. (maybe only during the load if you want point-in-time recovery during the rest of the day)

I know reading that training kit for the 70-462 exam (Administring SQL Server 2012) would come in handy someday!

Thanks for the question.

Try posting the actual table DDL and some sample data, it will make the problem more clear for others.

Read the first link in my signature on how to do this.

You cannot see this in SSIS itself.

You'll need to go to the database and check if the query was executed.

You could also use SQL Server Profiler to verify if the...

Script task or script component? Last one is in the data flow, the...

The problem is that semester is not unique for each year.

"What?", do you think, "has he gone out of his mind?"

The answer is yes, but that's besides the point.

When you...

Just following a common practice in dimensional modelling, I would start with defining a unique index on your surrogate keys of the fact table.

(they should be unique, if not your...