Nice article. I thought that Edison said this:

Is there a separate quote of his just for "success"?

CozyRoc (6/18/2009)

---

John Rowan (6/18/2009)

---

Phil Parkin (6/17/2009)

---

You have mentioned "Script Task" and "Script Component" as if they are the interchangeable - they are not. Just for clarification, I'm assuming that you...

You never know when someone else might have the same issue as this in future - that's why not deleting your posts is a good idea, IMO. It's better that...

Thank you, John, for the considered and informed response.

All of that makes sense. But I need to get another strong coffee and read the Raw file stuff again to make...

You have mentioned "Script Task" and "Script Component" as if they are the interchangeable - they are not. Just for clarification, I'm assuming that you mean Script Task here?

If you...

GSquared is correct. The development environment for SSIS packages is Business Intelligence Development Studio (BIDS) aka Visual Studio.

You'll find the FTP task there ready and waiting ...

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...