Hi all,
Are there any best practices to follow when creating an SSIS package that imports data to a table that has FK constraint.
The table in question has a FK contraint of around 500 sites, the file im importing contains these sites and many many more.
I've created an SSIS package that takes the datasource file and imports it into the table and ignores any raised error messages. This works and the data is inputted but im sure there must be a better way of doing this where i dont have to ignore errors, etc.
Cheers,
Lee
--
I thought what I'd do was, I'd pretend I was one of those deaf-mutes.