If you need a few sites for Free training, see this article by Jack Corbet.

Ok,

1. Renaming a task: You cannot use any special characters. keep it to simple alphanumerics and you'll be fine.

2. Enumerator Config: I can tell you are using SS 2008 (BIDS)....

If you need a zip/unzip utility, check out this custom task:

http://cozyroc.com/ssis/zip-task

Hi there,

Add a Foreach loop container to your package and place the Data Flow task inside it.

Configure the Foreach loop:

- Collection Enumerator: Foreach File Enumerator

- Specify the location of the...