jjr.123 (7/11/2013)

---

hi ,

I have a master package which calls the child packages from a folder dynamically, when i tried this with execute package task inside a for each loop container...

Some pointers:

1) Create one extra output in your Script Component. And change the ExclusionGroup property for both to a non-zero value (same value for both).

2) The SynchronousInputID property of the...

here is a Custom Foreach Folder Enumerator:

http://microsoft-ssis.blogspot.com/2012/02/custom-ssis-component-foreach-folder.html

Here is a Foreach FTP File Enumerator 2008 & 2012

http://microsoft-ssis.blogspot.com/2012/01/custom-ssis-component-foreach-ftp-file.html

2012 version:

here is an other example:

http://microsoft-ssis.blogspot.com/2011/03/get-file-properties-with-ssis.html

Jayanth_Kurup (8/7/2011)

---

This is just another option. You could easily have all these operations being performed as part of a simple bat file containing the FTP commands and have SSIS execute...

Here is an example of creating a Foreach Loop FTP file enumerator:

http://microsoft-ssis.blogspot.com/2011/08/foreach-ftp-file-enumerator.html

Here are some alternatives

http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.html

teekay-101299 (2/29/2008)

---

Per Microsoft: http://msdn2.microsoft.com/en-us/library/ms136033.aspx

The Script component does not support the use of breakpoints. Therefore, you cannot step through your code and examine values as the package runs. You can monitor...

This can be solved by using collations:

http://microsoft-ssis.blogspot.com/2011/03/sorting-in-sql-vs-sorting-in-ssis.html

Why don't you use a Script Task to unzip or to zip your files in SSIS. That way you don't need a zip tool and you don't get unexpected situations...

Here is a more detailed Script that also shows the datatype.

If the files have different stuctures, the foreach loop won't work. Unless there is some way...

1) Run a query to get your folders from that table with an Execture SQL Task (resultset=Full result set) and store the result in a variable.

2) Use a Foreach Loop...

maan_mustafa (12/6/2007)

---

Hello everyone,

I have a question , this is my first question here, I have SSIS package loop through folder and import the CSV files to DATABASE , my question...