You can always specify your own name for the constraint using the following syntax

col1 int CONSTRAINT [yourname] FOREIGN KEY REFERENCES othertable(PK))

For converting the number to a date, you can use the DateSerial function:

Description

Returns a Date value representing a specified year, month, and day, with the time information set to midnight...

Raise the value for the MaximumErrorCount property of your For Each container. By default it is set to 1 which makes the loop stop iterating when an error is...

My pleasure.

Coalesce will work as well. ISNULL is said to be a tiny bit more efficient, coalesce on the other hand is ANSI standard...

A difference with ISNULL is that coalesce...

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

Change the select * part of your query to something like this

select ...

,isnull([01],0) as [01]

,isnull([02],0) as [02]

...

Because you say your table is big and you don't seem to have the right indexes, you can use the following as an alternative to doing a select distinct or...

You're welcome.

Can't help you with the link - I'm not a programmer myself :-).

Actually, you do not really need a script task to solve your problem: you can use an...

Try this:

Public Sub Main()

Dts.Variables("Datum").Value = Right("0" & DateAdd(DateInterval.Day, -8, Today).Year, 2) & Right("0" & DateAdd(DateInterval.Day, -8, Today).Month, 2)...

To get the syntax correct, you should remove the word cursor and move the line starting with INTO before the from statement, similar to:

SELECT columns

INTO #temptable...

If you want to learn about BI from a business perspective, I would recommend Successful Business Intelligence: Secrets to Making BI a Killer App.

If you are looking for something more...

I use a multi-tier approach. Basically, all my configuration settings are stored in a sql server database. To point my packages to this database, I use an indirect configuration. This...

There are no precedence constraints in a Data Flow Task. I guess this is either a bug or by design. It would indeed be more convenient in some situations for...

Add a Row Count Transformation between your Conditional Split and your Script. In the Script, check the value of the row count: if it is 0, leave your variable unchanged,...

The following also seems to do the trick (I'm using SQL Server 2008) and is more elegant than the For Loop:

on the properties of the Event Handler (note that I...