Is this a SSIS use case? (new to SSIS)
I am currently starting the initial design for a solution which is basically doing some data transformation from one file. The basic procedure is like this:

 - The application gets one file per day copied to a network location (size is currently unknown)
 - The file should then be copied to another location as a backup
 - Then the file should be processed: The format is pretty to parse and nothing fancy in there
 - The file contents are to be written to a database (sql server)
 - If everything went well, the original file should be deleted (the backup copy should be kept)

My boss is repeatedly suggesting to use SSIS for this, but i have never used it before, so i am not sure if i can implement this purely with SSIS, especially the actions that should be taken on the file. Also, i am not sure if its a good decision to use SSIS if i dont really know how to work with it. 

Is that a typical SSIS use case? Can this be implemented using pure SSIS?

Is this a SSIS use case? (new to SSIS)
===

I am currently starting the initial design for a solution which is basically doing some data transformation from one file. The basic procedure is like this:

 - The application gets one file per day copied to a network location (size is currently unknown)
 - The file should then be copied to another location as a backup
 - Then the file should be processed: The format is pretty to parse and nothing fancy in there
 - The file contents are to be written to a database (sql server)
 - If everything went well, the original file should be deleted (the backup copy should be kept)

My boss is repeatedly suggesting to use SSIS for this, but i have never used it before, so i am not sure if i can implement this purely with SSIS, especially the actions that should be taken on the file. Also, i am not sure if its a good decision to use SSIS if i dont really know how to work with it. 

Is that a typical SSIS use case? Can this be implemented using pure SSIS?
