Im also going to do MCITP 70-450 .microsoft havnt mentioned or published what are the recommended books

Thanks Elliot for yor reply. it's clear to me. for the next times only the new and updated records will be upload to remote server.The issue is with the first...

Create a SSIS Package with Dataflowtask , Dataflow task enable you to transfer oledb source to oledbdestination.

Use fastload option to load the data quickly and and increase the networkpacketsize of...

Hi All

Thanks for the reply. this is a one time job. Eventhough in the future frequently have to update these amount of data in the remote server . is there...

Hi Elliot

I have created a SSIS Package using C# because i wanna create ssis package dynamically from my application. it will create the same as SSIS package with data flow...

Hi

Im using fastload to load data in destination.i have optimize the ssis task up to around 50% increasing the networksize of the connection Manager. But i wanna do it...

Images are saved in the database. i wanna import those data (around 3 million records) to remote database. i going to import those data via SSIS. what are the best...