tag:blogger.com,1999:blog-2303058199815958946.post7405784540786526611..comments2024-03-14T12:53:26.821+01:00Comments on Microsoft SQL Server Integration Services: Custom SSIS Component: Foreach Sorted File EnumeratorJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-2303058199815958946.post-2210310175144670312019-10-28T12:05:52.298+01:002019-10-28T12:05:52.298+01:00Hi Joost,
Is it possible to install the enumerato...Hi Joost,<br /><br />Is it possible to install the enumerator with VS2017 with SSDT?<br /><br />Regards,<br /><br />EdoEdo van Loonhttps://www.blogger.com/profile/04470934869934164388noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-2895005658788827092019-10-28T11:48:52.041+01:002019-10-28T11:48:52.041+01:00Hi Joost,
Is it possible to make the enumerator w...Hi Joost,<br /><br />Is it possible to make the enumerator work with VS 2017 with SSDT? I can open my 2012 packages in it, but the ones with your enumerator fail.<br /><br />Thanks,<br /><br />Edo.Edo van Loonhttps://www.blogger.com/profile/04470934869934164388noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-91542938612948100192018-01-11T10:09:21.477+01:002018-01-11T10:09:21.477+01:00Thank you. It workedThank you. It workedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-66038606744001490002018-01-10T16:35:26.239+01:002018-01-10T16:35:26.239+01:00You also need to install the 32bit version for vis...You also need to install the 32bit version for visual Studio.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-27449003765342485722018-01-10T16:12:14.877+01:002018-01-10T16:12:14.877+01:00Hi,
I downloaded & installed the installer as...Hi,<br /><br />I downloaded & installed the installer as suggested in the article. My machine is 64-bit version, I installed as mentioned to select "C:\Program Files\Microsoft SQL Server\110\DTS\" as it is 2012. But After refreshing I am unable to see this enumerator in the list.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-27142508910308365502017-03-22T10:47:08.223+01:002017-03-22T10:47:08.223+01:00Thanks Joost, the solution was in you last sentenc...Thanks Joost, the solution was in you last sentence, I was focusing on the creation of a new dedicated container but in fact you have right to "just" add an enumerator inside the foreach loop container keeping all the others properties of the container, just great ;)Anonymoushttps://www.blogger.com/profile/11173468512215318584noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-20326481242806432012017-03-21T23:24:46.131+01:002017-03-21T23:24:46.131+01:00And they won't be in the toolbox, but in the f...And they won't be in the toolbox, but in the foreach loop container as an option in the drop down field.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-34650475001067405542017-03-21T20:21:52.122+01:002017-03-21T20:21:52.122+01:001) Make sure you install the 32bit version for Vis...1) Make sure you install the 32bit version for Visual Studio (and the 64bit version for SQL Server)<br />2) Make sure you install on the same drive as you installed SQL Server<br />3) Check the folder [drive]:\Program Files\Microsoft SQL Server\130\DTS\ForEachEnumerators\ (110=2012,120=2014 and 130=2016). Do you see my enumerators and those from Microsoft?Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-86162194383831208012017-03-21T16:59:19.994+01:002017-03-21T16:59:19.994+01:00Hi Joost
I have got a problem with Bids 2015 and s...Hi Joost<br />I have got a problem with Bids 2015 and ssdt, installing all the dll, I verify their installation in all the SQL versions. But i cannot see the component in the toolbox. I try targetting all the 2012,2014,2016, but i never see the enumeration. <br />Have you an idea please ? <br />thanks a lot for your great job<br />David Anonymoushttps://www.blogger.com/profile/11173468512215318584noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-70630009992325998772016-12-29T18:51:25.288+01:002016-12-29T18:51:25.288+01:00Yes it works in 2016. Install both 32 and 64 bit o...Yes it works in 2016. Install both 32 and 64 bit on the same drive as SQL Server is installed.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-58815501509616032192016-12-29T16:44:04.769+01:002016-12-29T16:44:04.769+01:00Will this work with VS 2015/SQL 2016? If not, do y...Will this work with VS 2015/SQL 2016? If not, do you intend on making a compatible version?Matthew Lehnhttps://www.blogger.com/profile/10109826236413712105noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-6635483627956414122016-03-18T16:47:16.796+01:002016-03-18T16:47:16.796+01:00Thanks a lot. I easily can wait ;-)Thanks a lot. I easily can wait ;-)Anonymoushttps://www.blogger.com/profile/05951480657436575872noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-34610281459712067572016-03-18T16:36:54.853+01:002016-03-18T16:36:54.853+01:00Great idea. Then you can fill an extra variable in...Great idea. Then you can fill an extra variable in the Foreach Loop Variable Mappings pane that contains the creation or modified date of the current file.<br />Will think about this and do some testing. Could take a while because I first need to create 2016 versions of all my components before I start adding new features.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-50535581415462742222016-03-18T16:07:00.175+01:002016-03-18T16:07:00.175+01:00Good idea, but i just meant a possibillity to catc...Good idea, but i just meant a possibillity to catch the value of the date field. You sort the date, but i've so far no chance to get the value itself and use it in the program.Anonymoushttps://www.blogger.com/profile/05951480657436575872noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-6336598660547291942016-03-18T15:59:46.026+01:002016-03-18T15:59:46.026+01:00Do you mean like an extra filter to get only files...Do you mean like an extra filter to get only files where the create date is between two dates or where the create date is before/after a certain date?Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-19154875315581716712016-02-26T13:42:43.103+01:002016-02-26T13:42:43.103+01:00Hi
it's great.
Additional question: Can we g...Hi<br /><br />it's great.<br /><br />Additional question: Can we get the creation date also as an additional parameter to use it in the programme ? That would be most useful. Thanks KlausAnonymoushttps://www.blogger.com/profile/05951480657436575872noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-32445044047355337322015-02-12T23:08:44.120+01:002015-02-12T23:08:44.120+01:00The DelayValidation property worked perfectly. Th...The DelayValidation property worked perfectly. Thank you! This component now works like a dream.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-45915883948478517022015-02-12T20:49:05.564+01:002015-02-12T20:49:05.564+01:00Is the expression always returning a valid folder?...Is the expression always returning a valid folder? If you are using a variable in the expression then it should contain a valid value. You could also try setting the DelayValidation property on true if it doesn't contain a valid value on designtime.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-46565096242956379662015-02-12T20:36:56.816+01:002015-02-12T20:36:56.816+01:00I believe I tried exactly what you said. I used a...I believe I tried exactly what you said. I used a dummy folder "d:\" and then used a variable to override the Directory property on the Collection tab. Once I added the expression, the dummy folder disappeared, which I didn't think was going to be a problem because that is the same thing that happens for the regular Foreach File Enumerator. However, when I try running the package, I get the Directory is mandatory error. This error only happens when I try overriding the Directory property.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-48851804665833086692015-02-12T19:08:03.450+01:002015-02-12T19:08:03.450+01:00You could fill in a dummy folder "d:\" a...You could fill in a dummy folder "d:\" and then override it with an expression on the Directory property in the Collection tab of the enumeratorJoost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-53479222542922507762015-02-12T16:48:48.872+01:002015-02-12T16:48:48.872+01:00I love this. However, I have run into one issue. ...I love this. However, I have run into one issue. When I assign a folder under Enumerator configuration, it works great. When I use a variable to assign the directory dynamically as an expression, I get "Directory is mandatory". Any ideas?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-78596878518044696822014-12-23T23:00:36.484+01:002014-12-23T23:00:36.484+01:00Yes it should also be installed on the production ...Yes it should also be installed on the production server where the package is runningJoost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-74513777549664896342014-12-23T22:57:18.641+01:002014-12-23T22:57:18.641+01:00If I install this on my local machine and use the ...If I install this on my local machine and use the custom task to create a package will the custom task need to be installed on the server from which it is run in production?WoundedEgohttps://www.blogger.com/profile/10587474211232415755noreply@blogger.com