How can I load a large flat file into a database table using SSIS Assuming you are using SQL Agent or similar schedulerReqs 14 I would have a precursor step handle the FTP andor file copy steps.I dont like to clutter my packages with file manipulation if I can avoid it.Reqs 23 At the control flow level, the package design is going to look like an Execute SQL task connected to a Data Flow connected to another Execute SQL task.Ssis Update Table Using Script Task And Script' title='Ssis Update Table Using Script Task And Script' />
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |