SSIS

Replacing Legacy VB Script with SSIS

Overview of project to replace legacy VB script process with SSIS focusing on the usage of script tasks.

Continue reading →

Wouldn't You Want to Know Your SSIS Job Failed and Why? I think you would? Here is how.

Learn how to use an expression task in SSIS to capture and report on errors.

Continue reading →

Unpack zip files with SSIS Script Task. It is easier than you think.

Learn how to unpack zip files with an SSIS script task.

Continue reading →

Archiving and Deleting Empty Files with a Script Task

Learn how to archive files while removing empty files with an SSIS script task.

Continue reading →

Downloading Files from the SFTP Server

Learn how to download files via SFTP using WinSCP and SSIS.

Continue reading →

Accessing Directories on Remote Servers Using SSIS

Learn how to access directories on a remote server using an SSIS execute process task.

Continue reading →

Creating a Dynamically Named Folder Structure with SSIS

Learn how to create a dynamically named folder structure with SSIS. In this example, we will be creating a folder structure based on the current date.

Continue reading →

Verifying File Existence With SSIS

Learn how to perform a file existence validation with an SSIS script task in this tutorial.

Continue reading →

Use SSIS with WinSCP to Download Files Via SFTP

Learn how to use an SSIS Script Task with WinSCP to download files.

Continue reading →

Use SSIS with WinSCP to Upload Files Via SFTP

Learn how to use SSIS with WinSCP to upload files via SFTP.

Continue reading →

Looping through Files Within a Directory Using SSIS

Learn how to loop through files within a directory using SSIS.

Continue reading →

How to Use an SSIS Script Task to Send Email

Learn how to use an SSIS script task to send email.

Continue reading →

Use file system task to delete directory contents

Learn how to use a file system task in SSIS to delete directory contents.

Continue reading →

Copying and Updating a Tab Delimited Text File with SSIS

Learn how to copy and update a tab delimited text file with SSIS.

Continue reading →