tag:blogger.com,1999:blog-2303058199815958946.post2460174885415597865..comments2024-03-28T10:36:35.016+01:00Comments on Microsoft SQL Server Integration Services: How to configure a Foreach Loop Container: Sorted File EnumeratorJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-2303058199815958946.post-51414538718569530952018-01-10T21:44:14.716+01:002018-01-10T21:44:14.716+01:00This is great! Worked flawlessly.
Thanks!This is great! Worked flawlessly.<br /><br />Thanks!Drew Hansenhttps://www.blogger.com/profile/17592344713479094077noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-61896947767818962642015-01-21T17:28:40.155+01:002015-01-21T17:28:40.155+01:00Instead of assigning dsSorted to the dataset shoul...Instead of assigning dsSorted to the dataset should you assign filelistTableSorted? When I tried this the dsSorted had no rows but the filelistTableSorted did so I changed line 61 to use filelistTableSorted instead of dsSorted and it worked. I'm uncomfortable since no one else seemed to have the problem but it seems to be working now.WoundedEgohttps://www.blogger.com/profile/10587474211232415755noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-15175823483457251002015-01-02T14:58:38.521+01:002015-01-02T14:58:38.521+01:00For this example you should only configure the str...For this example you should only configure the string variable <strong>startlocation</strong>. The other variables are filled by the package. Giving them a default value via configurations isn't useful.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-68988330392484987712015-01-02T13:19:25.311+01:002015-01-02T13:19:25.311+01:00I found that I was not able to save my variables t...I found that I was not able to save my variables to a configuration file because the variable dataset was an object, even though I unselected it in so it wouldn't export.Have you encountered that? I'm going to try to work around that by using your component. I'm using BIDS 2008R2WoundedEgohttps://www.blogger.com/profile/10587474211232415755noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-55170382847794625962014-12-24T15:56:59.807+01:002014-12-24T15:56:59.807+01:00Excellent, thanks!Excellent, thanks!WoundedEgohttps://www.blogger.com/profile/10587474211232415755noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-9263355217957376482013-06-21T15:05:04.713+02:002013-06-21T15:05:04.713+02:00I tried your code today,
simply fabulous, thanks!I tried your code today,<br />simply fabulous, thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-54043009551826454912012-11-18T18:34:43.554+01:002012-11-18T18:34:43.554+01:00Hello Joost,
Thank you once again.
I found the i...Hello Joost,<br /><br />Thank you once again.<br /><br />I found the issue with my package, its not setting the correct variable for my dataflow task connection string. hence its not picking the flatfile. finally i got it working.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-7922458522033799272012-11-17T22:12:09.697+01:002012-11-17T22:12:09.697+01:00It's at the bottom of the post or click hereIt's at the bottom of the post or click <a href="https://sites.google.com/site/ssisblogspot/SortedForeachLoop.dtsx?attredirects=0&d=1" rel="nofollow">here</a>Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-72274102349453171192012-11-17T22:10:23.891+01:002012-11-17T22:10:23.891+01:00Hi Joost,
Thank you very much for taking time and...Hi Joost,<br /><br />Thank you very much for taking time and creating sample package to help me.<br /><br />Could you please provide me the link to download the package?<br /><br />I appreciate your help.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-26608254862524979732012-11-17T20:23:44.023+01:002012-11-17T20:23:44.023+01:00Example Package has been uploaded. Let me know if ...Example Package has been uploaded. Let me know if works for you.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-43398449113803670172012-11-17T07:14:09.449+01:002012-11-17T07:14:09.449+01:00I will create an example package and put it online...I will create an example package and put it online...Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-62782246328370360492012-11-17T04:21:16.998+01:002012-11-17T04:21:16.998+01:00Hi Joost,
I am using 2008 version and did the exa...Hi Joost,<br /><br />I am using 2008 version and did the exact same as this post but still its not working. I am trying to loop through the files in a folder in sorted order and import the text file data to DB. <br /><br />It will be really helpful to me if you could share your project. <br /><br />Thank you in advance.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-73084414957396367822012-10-24T14:30:40.027+02:002012-10-24T14:30:40.027+02:00Thanks Joost i am able to work through it.Thanks Joost i am able to work through it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-83140648208550805042012-10-24T11:37:09.973+02:002012-10-24T11:37:09.973+02:00I don't have 2005 on my pc, but you can use th...I don't have 2005 on my pc, but you can use the VB.Net version of the Script Task. Copy the lines of code from the main method to your own main method. Only the last row (setting script task result) has been changed in 2008, so you need to keep that from your 2005 script task method. And check if all the imports rows are there in 2005. If not add them.<br />Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-42352671945946873652012-10-24T11:04:39.459+02:002012-10-24T11:04:39.459+02:00Hi Joost,
I Use SQL 2005 BIDS, is there an SSIS p...Hi Joost,<br /><br />I Use SQL 2005 BIDS, is there an SSIS pacakge to download for 2005 please.<br /><br />Thanks<br />SenthilAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-41330742926319313232012-09-09T21:43:50.657+02:002012-09-09T21:43:50.657+02:00download 2012 package<a href="https://sites.google.com/site/ssisblogspot/ForeachSorted2012.dtsx?attredirects=0&d=1" rel="nofollow">download 2012 package</a>Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-84938643473615907972012-09-05T10:24:01.420+02:002012-09-05T10:24:01.420+02:00I can't get this to run in 2012. It would be ...I can't get this to run in 2012. It would be helpful if you had the SSIS package for download. Unknownhttps://www.blogger.com/profile/04543614268379117645noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-32047208762030485682011-11-17T20:51:37.659+01:002011-11-17T20:51:37.659+01:00@Vikram: For general SSIS questions you should pos...@Vikram: For general SSIS questions you should post a question at the <a href="http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/threads/" rel="nofollow">MSDN SSIS Forum.</a> This is a very active forum with lot's of helpful people.<br /><br />If you have problems with the script posted on this page, then contact me via the <a href="http://microsoft-ssis.blogspot.com/p/contact-me.html" rel="nofollow">contact page</a> and let me know what the exact error was.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-33217249065212527522011-11-17T07:55:13.169+01:002011-11-17T07:55:13.169+01:00My requirement demands me to use a extract based o...My requirement demands me to use a extract based on a date. And on success i need to pass the VDate variable value to Vsource variableand update the VDate variable to system date<br />i have initially given values for VDate and Vsource . <br />How can i use loop container , also i have some issues with the script that i've written , NEW to SSISVikramhttps://www.blogger.com/profile/14944450354886691322noreply@blogger.com