I had a similar problem with an ftp connection early in the process, adding the ftp password manually to the config file solved it, so i know that the config...

ok, thanks, ill give it a try

I totally understand scope with respect to standard development, but with SSIS I dont think its quite the same thing (thats my opinion anyway) Im really new to SSIS,...

I can see the logic behind this, its very confusing for a novice though, but allowing variables with the same name, even though they may be different scope, is crazy...

All my variables are created at the package level so they are global throughout, id expect to see them at all levels.

After several hours of headscratching ive found the problem. For some strange inexplicable reason, the Variable window decides to remove particular variables from view (not delete them, just hide...

Thats excellent, thank you.

ok, thanks, ive taken a look at how to use them. How can the actual information inside the config file be edited though ?

Ive run through the config wizard...

im still having problems with the FTP task. Ive setup a variable named 'SourceFTPFile'

Its scope is the entire package and its a string. In the value column I...

I have another question related to the FTP download. The name of the actual file will change from month to month, but the naming format will always be the...

the answer was obvious now, I hadnt set the local destination for the downloaded file

I think im slowly getting the hang of SSIS, its not particularly intuitive though, I was expecting to edit the variables in the edit window of the task, but had...

Im following this example here

http://sqlblogcasts.com/blogs/jorg/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx

but converting it to c#.

The process seems very 'flaky' to me. For example, If I give the Foreach process a...

Ive googled this and found these steps

Steps:

1. Drag and drop execute Process task

2. Edit the component.

3.In the Process Menu,

'Executable' =C:\Program Files\WinZip\WINZIP32.EXE

'Arguments'= -e -o "fileNameinZipformat.zip "

Working Dir='C:\TestFolder '

4. Arguments tips: -e...

Is it also possible to do the following with SSIS ?

use FTP to download a zip file to a specified location. Once this file has been successfully downloaded, unzip...