Does this assume SSIS Server is installed somewhere already? How detailed should the tasks be? Not sure what came in the original question so not sure how detailed this should get.
So something like:
- install SSDT, basic package
This would be the latest SSDT, just the SSIS component and building a basic package to import a CSV and put it into a table, right?
- add some tasks, maybe lookup, split, whatever
This is where some detail would be helpful. There are a lot of task types and all have their uses. Wondering if there were specifics mentioned in the original request. My thoughts on components would be:
Containers, Conditionals, Variables (for the next part), Lookups, maybe Conditional Split, and the OLE DB Command. Even that feels like a lot for one article.
- deploy to another server, maybe include environments or other changes.
This is where the variables/project parameters would come into play. I'd also assume that someone had an SSIS server already set up w/ the SSIS Catalog. Does that sound about right? Nothing fancy here trying to use PS or anything like that - just a straight deploy from VS (or ISPAC) and configure on the server.