SSIS Advice

SSIS and Import/Export
3

Thanks gbritton for your reply.
Also, you could implement a For Loop container and loop for some number of "tries"
Would you mind if you explain me in detail that part?

Two More questions Please..

  1. I know the best practice is read the data from Flat File and insert into Staging Table and then Staging to Production DB. Do you think that's the best way to go? and I know it will not faster than Reading data from a Flat file and Insert into Production.

  2. I am going to schedule this SSIS Package through SQL Server agent. The first step if the File is in the Folder run the package. Here my question is, It is easy for me to Schedule this job from Dev Server so I can easy control it, Drop my Package to Network Drive and Schedule on Dev Server to Insert the data into Production OR Drop the Package into Production Server and Schedule on Production Server to Insert the data into Production.

Please advice Thank You.