SSIS

Stop Error Propagation
- http://datachix.com/2011/02/08/messing-with-errors-in-ssis-or-does-the-propagate-property-really-exist/

Script Task

Using variables
- Copy to clipboard
```
Dts.Variables("fileName").Value
```

Display Message

Copy to clipboard

MsgBox("First line" & vbCrLf & _
       "Second line")

Check is file exists

Copy to clipboard

If (File.Exists(CStr(Dts.Variables("filePath").Value))) Then
      Dts.TaskResult = Dts.Results.Success
    Else
      Dts.TaskResult = Dts.Results.Failure
    End If

STFP, ZIP, PHP Excryption
- SFTP, encrypt or compress data files in SSIS using custom components
- http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/106616/
  - Web Site: http://ssisextensions.codeplex.com/releases/view/101949
  - 2008 R2 Download Link: http://ssisextensions.codeplex.com/downloads/get/623584
  - 2012 Download Link: http://ssisextensions.codeplex.com/downloads/get/616818

Display Datetime in Expressions

Copy to clipboard

(DT_STR, 4, 1252) DATEPART("yyyy", GETDATE()) 
+ "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm", GETDATE()), 2)
+ "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd", GETDATE()), 2) 
+ "_" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("hh", GETDATE()), 2) 
+ "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mi", GETDATE()), 2)
+ "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("ss", GETDATE()), 2)