December 10, 2025 at 2:46 pm
hi we have to replace talend which generally was used to move files.
talend's replacement except for a handful of sql sourced etl's is an OO code based "pipeline" architecture. the sql stuff has been converted to ssis.
we have to begin extracting about 6 files daily from an ftp server and throwing them out to a share drive for further consumption by ssis. one of us wants to make this the responsibility of the new "pipeline" architecture and team. another wants to investigate if that stuff can be moved instead by ssis (maybe fabric in the future).
cadence seems a pro for ssis. having yet another dept, support schedule and telephone call in the picture seems a con for the new pipeline. an "established" file movement process is a pro for the pipeline. In the past, flopping between 2 technologies to deal with a problem partly related to talend and partly related to ssis was awkward for a variety of reasons.
are ftp servers difficult to bake into ssis for flat file sources? how does the community feel about this choice in general?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply