This should help:

http://www.rafael-salas.com/2008/10/ssis-compress-files-using-execute.html

I wouldn't think this would work. There were some significant changes in SSIS from SQL Server 2005 to 2008, and I would expect that you'll get some grief when...

Dave,

That might make a good article in itself 🙂

Tim

John,

I ran into this not too long ago. What I found was that, although the service account had full rights to the target folder, there was a folder higher...

I just did a presentation for the Oklahoma City SQL Server User Group on how to use the script task to handle ragged or irregular files such as this:

http://okccoco.blip.tv/file/3874415/

hth,

Tim

Glad to help. I'd be interested to hear your thoughts after you try it.

There are a couple of ways you could handle this. First, you could use native SSIS components - using the Lookup Transformation, you could look up the records...

Sounds like you found the right setup. Yes, based on what you described, the For Each Loop works very well... you can create a variable to store the name...

You could do this using a script task, but it's probably easier to use a ForEach Loop, configured to use the Foreach File Enumerator. You'd specify the directory from...

If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task. You can open MIME-encoded mail file or download directly from POP3 or IMAP email server. The task...

CirquedeSQLeil (4/22/2010)

I couldn't find it anywhere. Thanks for sending it. ...

Yep - I work in BI and can contribute in that area.

Add me to those interested in seeing this succeed. I'm available with 2-3 hours per week - possibly more after little league baseball season wraps up next month.

When you say that it failed, is there a specific error message you receive? Most of the time if it works in dev but not after deployment, you're dealing...

As an aside, the SSIS service is usually not required to execute SSIS packages: http://msdn.microsoft.com/en-us/library/ms140100.aspx