I'm planning to develop a new SSIS project where I have a data in a table (Raw form) and I want to put into our production database. I just want to start with a test project and if you provide me little inside that will be helpful.
Here is what I'm trying to do
Typical order table (Order Header and Order Detail)
Temporary table with raw data which need to import in Order Table.
Order Header contains auto increment primary key which needs to be in order details table. So how should I develop a project where I go thru each record of temp table, write a record in order table, get order id (pk) and write data in order detail table.
Hope it is very much clear.
Hopefully I will get expert advice soon.
Thanks in advance,
mark it as answer if it answered your question :)
View Complete Post