Dear all, i have an urgent request from my company to moving flat file DB with fixed length to MSSQL . the reqired is : 1 - moving al the data from flat file to mssql 2008 . 2 - update the flat file with any insert & update & delete in mssql . 3- update mssql with any insert & update & delete in the flat file . can i have a plan and how i will do it . it looks like a replication to me . is ssis the best sulotion for that and how ? and what is the best bractice for that . regards,,

You can use the Flat File source in the dataflow to read the flat file and the OLE DB destination to write the data to SQL Server. What do you mean with "update the flat file"? Wouldn't it be easier to recreate the flat file from scratch?MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

we already have an old application access the flat file . the aproch is the make both the flat file and mssql same to each other .

Well, you can't use SSIS to update a flat file. It just inserts data. Either it overwrites the file, or it appends to it. You'll need to code .NET to do some sort of update in a flat file.MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

Hi AbdulAziz, Indeed SSIS is the best solution to implement your requirment. please gothrough the following snapshot which i have imoplemented in my client which performing the all three opertaions which required you. Please let me know if you required additional help in this regard. Regards, Zaim Raza.

Thank Zaim, it great . can u please explain in more details. is your client reqiered the same required that i ask. regards,,,

Hi AbdulAzia, Basically this process is performing the delta operation (create new records update existing one) as well as remove the old records which no more exists in the source. this process also creating the batch id for audit purpose which tells you exactly how many rows are inserted updated and deleted in this batch. hope this brief introduction helps you. please let me know if your required more detail in this regard. Thanks, Zaim Raza.