Synergyx,

Use this in SQL 2008:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

<System.AddIn.AddIn("ScriptMain", Version:="1.0", Publisher:="", Description:="")> _

<System.CLSCompliantAttribute(False)> _

Partial Public Class ScriptMain

Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

End Class

Enum ScriptResults

Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success

...

SSC-Enthusiastic ,

I actually used the WInZip command line tool to do the zipping. I used a Foreach Loop Container to list all the files in a folder, with a VB...

justpiyushmittal-1127780, check out this link also. It has some useful tips.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/da9c4117-8f43-4c61-a1b8-6214fdb97118

Add a switch to your execute command to run the zipping in the background.

Sandor

If you run it from the file, you have to make sure that your SQLServerAgent account has permission to the path containing the package. Also this user account has to...

Did you save a copy to the server or are you running it from file? Do you have a proxy account set up to execute the package? Do you use...

First of all, nice article.

I worked on a similar project before, and I also used an Execute Process task with WinZip to handle the zipping part. However, I didn't use...

I had similar flexibility problem with the Send Mail task, but I used a different approach to overcome it. I used a SQL query and redirected the result to a...