Thank you Livingston for the answer.

WE use CozyRoc SSIS+1.3 for SQL 2005

and CozyRoc SSIS+1.4 for SQL 2008

We donot have the Key to decrypt the file.

We use SQL Server 2008 and Cozyroc+1.3

We use FTP Conncetion Manager.

We are not using the SFTP Task.

We put the files in a FTP Server.

They just grab the files from there.

Hi

I encrypted a text file using OPENpgp Task provided by CozyRoc.

When the other end of the line is trying to decrypt it, they receive a error saying that,

ERROR:

Decompressed

faile:/<FILEPATH>

for...

Hear is one way that i can suggest to everyone for converting Flat File to XML using the Script Component "Destination" in the data flow task.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports...