Category Archives: SSIS

Importing multiple text files using SSIS

We can import multiple flat files in one go using the MULTIFLATFILE connection manager. This can be used in scenarios where you have multiple files with the same format lying in a directory and you want to import records from … Continue reading

Posted in Programming, SSIS | Tagged , , , , , , , | 17 Comments

SSIS: Sending mail using Script Task to a secure SMTP

Today a client reported that the SSIS had failed after they turned their SMTP server to a secure one. To my surprise i found out that there is no provision in the Send Mail Task to specify SMTP user name … Continue reading

Posted in Programming, SSIS | Tagged , , , | 3 Comments