Hi John

If we take away the staging table and do the import directly, using SSIS, how best do you deal with all of the FKs that need to be populated?...

Define what you mean by 'correct'.

Extracted to what? A CSV file?

Do you mean some sort of verification process? What is your concern - is it that records get missed, or data somehow gets corrupted?

Not really, because you do not have all the foreign key information that you require at that point.

Also, is there ever a need to update existing rows in the database,...

OK, sorry if I was not clear.

Once your data is in a staging table, there will be a series of SQL statements which need to be executed to INSERT or...

Aha, OK, now I understand.

You need to load your master data first (ie the stuff on the 'one' side of one-to-many relationships) - Site then Student then Exam, by the...

Your question is a bit too broad. It sounds like you have decided on a process for your SSIS package, ie, something like:

1) Truncate staging table

2) Load from CSV into...

So if you set the text qualifier to None, does the problem go away?

If you check the properties for your destination flat file connection, has Text Qualifier been set to {none} - but in angled brackets (they won't render here)?

You could also set...

I'm afraid that your logic is not quite sound 🙂

You are setting Bin1, Bin2, ..., Bin9 to the same value for each letter in the binary string - so they...

Wow, that's what I call dedication - get that man a beer!

tobe_ha (6/9/2009)

I tried to understand the structure of the xml in the package. When I format the xml, afterwards the package cannot be loaded. "Error loading ..."

How can that be?...

You have multiple sources and 1 destination - so surely it is your source data which should be dynamic and the destination which should be fixed?

Why not use a SQL...

This thread might be of interest:

http://www.sqlservercentral.com/Forums/Topic463182-148-1.aspx

Nice solution. What happens if the expression evaluates to FALSE? I'm assuming that control flow doesn't just stop because there is no onward path?

Yeah, I know I should know the...