Implement If condition in SSIS package

Posted by on Nov 18, 2009 in SSIS | No Comments

This is common requirement , you need to implement a If condition of If then else condition in a SSIS package flow. The example below illustrated it and implemented it with Precedence Constraints. Problem Scenario: there is a table in sql data source , If any records exist in this table then a Data Flow ...

Read More

How to work with multiple files in FTP Task

Posted by on Nov 11, 2009 in SSIS | No Comments

FTP Task is one of SSIS tasks for File Upload,Download or manage ftp file and folders, FTP Task Configuration is easy and all things that must be done is that create a FTP Connection Manager and then set File Transfer configurations. But problem is when you must do this with more than one file, Answer ...

Read More