Menu
ssis Move file from one folder to another From the Control Flow tab in your SSIS package, look in the SSIS Toolbox in the common section for the File System Task, drag this onto your design surface where you want the file move to happen in your package. Once you've placed the task, double click to open it.
First, open SQL Server Data Tools (SSDT) and create a new Integration Services project: In the package designer, select Control Flow and from the SSIS Toolbox, drag and drop a Bulk Insert Task component: Then, right-click over the Bulk Insert Task and select Edit... to configure it (You can also just double-click it).
I have an SSIS (dtsx) package that imports data from a text file. How can I move the text file as a step within the SSIS package after importing the data? Is there a command line utility, or do I have to write a program to do this?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With