Overall Satisfaction with SQL Server Integration Services
We use SQL Server Integration Services to pull data from FTP sites.
- Our clients have branches and each branch generates a flat file and loads to a remote site from which we pull and consolidate the data and report from the consolidated data.
- SSIS would allow [us] to execute a batch file which will pull the files and decrypt.
- SSIS transformations are easy to use when [they] loop around the files in the same folder.
- SSIS expressions are difficult to read and comprehend.
- SSIS fuzzy loop up transformation performance needs to be optimized.
- SSIS packages code should be easy to copy and modify so that it can easily be replicated just like BIML.
- Automation leading to cost savings due to less headcount
- Eliminate redundancy
- Better customer service
- Informatica