Use an execute process task with PSFTP - no need to shell out $$$ for /n software's SSIS task.

Tommy

Correct - export to File System, launch VSS, create a new project and choose add existing item from the SSIS packages folder in VSS. Select file system again and browse...

Open SQL Management Studio - connect SSIS. Expand the stored packages folder. Locate the saved package, right-click and select export package. An alternative - launch VSS, create a new SSIS...

NP - e-mail me at freebsdboy@gmail.com and I can you send you an example.

Thanks.

Tommy

I've been using GnuPG within a BAT file in an execute process task within SSIS to perform encrypt/decrypt operations. i.e.

Example BAT file:

@echo off

gpg --encrypt -r "someone@somekey.com %1

Example Execute Process...

Use a script task to populate a boolean variable to determine if the file exists (in this example, using varFileName, varFileExists). Then use an expression (i.e. @[User::varFileExists]==True) on the precedence...

Hi Imke,

Your message source can be anything you want; you can build an expression using variables, etc. i.e.

"THE FOLLOWING FILE HAS BEEN TRASMITTED TO SOMEHOST VIA FTP." + "\n" +...

not sure about this error - I've used something similar to this in the past -

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Dts.Runtime

Imports Microsoft.SqlServer.Management.Smo

Imports Microsoft.SqlServer.Managment.Smo.Agent

Imports Microsoft.SqlServer.Managment.Common

Imports System.Data.SqlClient

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application()

Dim pInfos As PackageInfos...

You could always use ServerName@domainname.com in the FromLine of the Send Mail Task (so long as your SMTP server accepts this as a valid address). You can acomplish this...

Have you launched the surface area configuration tool and enabled remote connections unde the database engine? By default SSIS runs under NT AUTHORITY\Network Service - try changing to a domain...