tag:blogger.com,1999:blog-2303058199815958946.post5621305401582344259..comments2024-03-28T10:36:35.016+01:00Comments on Microsoft SQL Server Integration Services: Custom SSIS Component: Foreach Folder EnumeratorJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-2303058199815958946.post-223499038096180172019-10-28T15:16:09.587+01:002019-10-28T15:16:09.587+01:00Joost,
Can the sorted enumerator be installed wit...Joost,<br /><br />Can the sorted enumerator be installed with VS2017 SSDT. I can open VS2012 packages in it, but can't get it ot work with your add-ons.<br /><br />Regards,<br /><br />Edo.Edo van Loonhttps://www.blogger.com/profile/04470934869934164388noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-5606571757921860542016-12-21T08:46:15.226+01:002016-12-21T08:46:15.226+01:00Make sure you install both 32bit and 64bit. And mo...Make sure you install both 32bit and 64bit. And more important, make sure you install it on the same drive as SQL Server.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-75545753225030109282016-12-20T20:05:01.066+01:002016-12-20T20:05:01.066+01:00This didn't work for me. I don't see a ...This didn't work for me. I don't see a 'foreach folder' enumerator added in SSDT. I tried on both SQL Server 2012 and 2014priyankahttps://www.blogger.com/profile/08608144393545700205noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-55707646652285316192016-03-18T14:53:40.568+01:002016-03-18T14:53:40.568+01:00Hi Luke K,
Sorry for the late replay, finally had...Hi Luke K,<br /><br />Sorry for the late replay, finally had a change to add the 2014 and 2016 version. Also added new option to let the enumerator fail if the folder is empty.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-7035119780625571072016-03-18T14:53:16.049+01:002016-03-18T14:53:16.049+01:00Sorry, finally had a change to add the 2014 and 20...Sorry, finally had a change to add the 2014 and 2016 version. Also added new option to let the enumerator fail if the folder is empty.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-59990868794375396002015-12-17T01:26:26.334+01:002015-12-17T01:26:26.334+01:00Is the 2014 version still being worked on? Downloa...Is the 2014 version still being worked on? Download page lists it as soon.Luke Khttps://www.blogger.com/profile/08148315719816798736noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-6008701504770136062015-12-08T21:39:38.879+01:002015-12-08T21:39:38.879+01:00Is a 2014 version in the works?Is a 2014 version in the works?Luke Khttps://www.blogger.com/profile/08148315719816798736noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-15478703874365685682013-07-12T17:52:10.740+02:002013-07-12T17:52:10.740+02:00If you want to have to folder with the highest num...If you want to have to folder with the highest number in it you could sort the loop ASC and then when the loop is finished the variable will contain the last folder with the highest number. It's only possible if the numbers have prefixes 001, 002, 003, etc. or don't have numbers higher then 9.<br /><br />If that's not the case then you need a Script Task with some .Net code to do that for you.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-76219236535243057272013-07-12T17:07:21.779+02:002013-07-12T17:07:21.779+02:00Joost, using the Folder enumerator, how can I sto...Joost, using the Folder enumerator, how can I store a subfolder name in a variable.<br />I have Folder1, Folder2, Folder3. I want to return the largest folder number(folder3) and store it in a variable. ThanksAnonymoushttps://www.blogger.com/profile/02988692910318495644noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-23365645883274157632012-11-09T20:25:46.270+01:002012-11-09T20:25:46.270+01:00Sorry, I only have a 2008 and 2012 version. But ch...Sorry, I only have a 2008 and 2012 version. But check the link at the top of this page for alternative solutions that also work for 2005.<br /><br />Regards,<br /><br />Joost<br />Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-9229438670084223402012-11-09T17:43:18.393+01:002012-11-09T17:43:18.393+01:00Hi this looks really good, but we're stuck on ...Hi this looks really good, but we're stuck on SQL 2005. Is this tested / compatible with SQL 2005?<br />Alexhttps://www.blogger.com/profile/04031117169483211844noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-84696296887548540142012-08-20T09:04:19.450+02:002012-08-20T09:04:19.450+02:00Please post the comments on the right article: htt...Please post the comments on the right article: <a href="http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html" rel="nofollow">http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html</a>Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-92026143690766449502012-08-18T18:46:20.182+02:002012-08-18T18:46:20.182+02:00Thank you for your response,
I am using 2008 versi...Thank you for your response,<br />I am using 2008 version, i don't have permissions to install custom enumerator.<br />Actually i am looking some change in the script task (to include parent folder) which you provide for looping over subfolders, the output of the xml path contains only subfolders.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-13549561186832168472012-08-17T23:28:41.131+02:002012-08-17T23:28:41.131+02:00@Anonymous: Which version of SSIS are you using an...@Anonymous: Which version of SSIS are you using and did you install the custom enumerator? Also see the screenshots above. Any differences?Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-61493886969375457172012-08-17T23:14:03.747+02:002012-08-17T23:14:03.747+02:00sorry for asking again,
i cann't see "inc...sorry for asking again,<br />i cann't see "include rootfolder" checkbox in my foreachloop container<br />Thanks<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-90445444035647144872012-08-17T20:58:41.727+02:002012-08-17T20:58:41.727+02:00@Anonymous: I'm not sure what you mean, but pl...@Anonymous: I'm not sure what you mean, but please use the SSIS MSDN Forum for general SSIS questions. I'm a regular reader of that forum: <a href="http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/threads/" rel="nofollow">http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/threads/</a><br /><br /><br /><br />Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-43372667717748840242012-08-17T16:37:57.407+02:002012-08-17T16:37:57.407+02:00Hi Joost,
Actually i am using standard for each f...Hi Joost,<br /><br />Actually i am using standard for each file enumunator, then how to send parent folder along with childfolder.<br /><br />Thanks for your responseAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-88870062497851961562012-08-17T06:43:06.243+02:002012-08-17T06:43:06.243+02:00There is a ckeckbox "include rootfoler"There is a ckeckbox "include rootfoler"Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-83615368797453578802012-08-17T04:08:07.729+02:002012-08-17T04:08:07.729+02:00i have one moreQuestion, how to include parent fol...i have one moreQuestion, how to include parent folder along with subfolders.<br />Thanks<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-65483078862647452762012-08-17T03:38:04.493+02:002012-08-17T03:38:04.493+02:00Thank you Joost for your quick response, helped me...Thank you Joost for your quick response, helped me lotAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-61316329931049402152012-08-16T22:59:39.839+02:002012-08-16T22:59:39.839+02:00I haven't tested zip folder yet, but for now y...I haven't tested zip folder yet, but for now you could add a dummy task within the foreach loop and connect it to your first task. Add an expression on the Precedence Constraint between them that tests for .zip in the foldername. Something like: LOWER(RIGHT(@[User::FolderPath),4)) == ".zip"<br /><br />Will publish an update if I can replicate it and when I have a solution for it.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-90382345808588024012012-08-16T04:21:41.314+02:002012-08-16T04:21:41.314+02:00how to avoid zip folders in the subfolders,when fo...how to avoid zip folders in the subfolders,when forming xml Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-83868546769114994542012-07-25T08:53:07.518+02:002012-07-25T08:53:07.518+02:00I tested it with d:\folder\subfolder\ and \\server...I tested it with d:\folder\subfolder\ and \\server\share\folder\Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-71272158996518017762012-07-25T05:18:49.443+02:002012-07-25T05:18:49.443+02:00Hi are you able to use unc paths?Hi are you able to use unc paths?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-3460622368091019262012-02-03T21:36:10.760+01:002012-02-03T21:36:10.760+01:00Thanks. Will think about it... for now you have to...Thanks. Will think about it... for now you have to combine the two enumerators to accomplish your request.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.com