Hi all, we are rewriting a large number of DTS packages, I have done a quick sample audit of the packages, typically they involve any combination of the below;
1) Deletion of existing files,
2) Running a SQL statement or batch file,
3) Connecting to a SQL/Excel source/destination, importing or exporting data to or from it;
4) Sending emails indicating which of the previous elements failed, or overall success.
There are several packages containing ActiveX Scripting, though they SEEM only to either check whether a csv/txt file exists, rename it, or make a copy of it to a network drive and delete the original.
What are transformations in SSIS I need to create the packages?