Developing Steps
The data upload project in SSIS starts with launching the Visual Studio shell, and selecting the New Project on the left. Default folder could be selected as the project folder.
A customized project folder could be used but because of a possible long folder path an error could be returned. There are lots of different controls that may seem overwhelming at first, focus will be the two main things. The middle section which is the main workspace and the SSIS tool box on the left. As shown in the image, at the top of the main section there are 5 categories. The two categories, control flow and data flow will be used in the projects shared here.
From the data flow task drag it into the main working area and the Data Flow task is created. It's as simple as that.
All of the work in SSIS will be drag and drop. Double-clicking on the data flow task will take the user to the data flow window. In simple terms, a control flow is the process that kickstarts the data flow. There's a certain hierarchy between the two. The data flow is where it specifies which files need to be uploaded and where they go.
To keep it organized, renaming the task using the date convention with adding the name at the start is useful as it shows the date the upload was set up. Here more detailed process info is shared here.