It seems that there is a problem with your logging in SSIS.

How did you configure your log provider?

At first sight, I can't spot any errors either in your expression.

Are all the quotes still there, or are some of them replaced with empty strings?

This topic should point you in the right direction:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ff610236-9065-4868-8bf0-9ce622886657

However, it is much easier (and also pointed out in the above discussion) to create a job that runs the package and...

It is a good question about the basics, but not a very original one. I believe this sort of question has already been asked multiple times.

There is an option at the SORT transformation to remove duplicates. But see my...

da-zero (8/20/2010)

---

Where exactly are there duplicates?

In your source or at the destination?

If there are duplicates at the source, performing a lookup while you are writing to the table destination will...

You'll find a great explanation of the different dimension types in Kimball's book "The Data Warehouse Toolkit" (2nd edition).

Actually, to be precise, a dimension is not of SCD type 1,2,3...

Don't forget the " at the beginning of the code.

Is the conversion to DT_DBDATE necessary?

How do you get a PK violation?

Are you inserting the PK values yourself?

Almost 🙂

"Enkel" means "only" (in the sense of...

You're just being sponsored by McDonalds 😛

If the SSIS package runs on the same server as the destination table, you can use the SQL Server Destination, which is the fastest.

You can try to write the data to a staging table first.

Then call the UDF in the database itself and write the results to your final destination table.

This is all...

I have done the following things the past year to improve my skills:

* read technical books (Kimball, SSIS et cetera) in my free time

* studied for a certification in my...

You should store the code I gave you in a variable (which is actually an expression who sets the value of said variable). Do not use it directly in the...