CODEWITHSUNDEEP
sql-serversql-server-2008ssis
maurox
maurox

Reputation: 1292

How to move a text file after importing the data using SSIS package?

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?

Upvotes: 11

Views: 29370

Answers (1)

user756519
user756519

Reputation:

You could use File System Task available in the Control Flow tab of the SSIS package to move files from one folder to another.

Here are some examples that show how to move files between folders.

How do I move files to an archive folder after the files have been processed?

How do I create a package that would copy all files from a given folder into a new folder?

Upvotes: 10

Related Questions