tag:blogger.com,1999:blog-2303058199815958946.post2354250619146710687..comments2024-03-28T10:36:35.016+01:00Comments on Microsoft SQL Server Integration Services: Custom SSIS Component: Zip TaskJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger51125tag:blogger.com,1999:blog-2303058199815958946.post-36063565236410595802017-02-06T17:25:40.481+01:002017-02-06T17:25:40.481+01:00I see it now, 'DeleteSource'. Thank you fo...I see it now, 'DeleteSource'. Thank you for the quick reply.Rhttps://www.blogger.com/profile/06886188137124859134noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-13011057502454919442017-02-06T14:00:52.631+01:002017-02-06T14:00:52.631+01:00It's already there, but only visible in the pr...It's already there, but only visible in the properties of the task (not in the editor).Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-87147803368627896232017-02-06T09:44:40.854+01:002017-02-06T09:44:40.854+01:00This is a great ssis addon. Any chance a "re...This is a great ssis addon. Any chance a "remove-files" feature could be added which could delete the input file(s)?Rhttps://www.blogger.com/profile/06886188137124859134noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-22500387837951094702016-12-07T07:02:51.965+01:002016-12-07T07:02:51.965+01:00Make sure you installed on the same drive as SQL S...Make sure you installed on the same drive as SQL Server.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-76538217606965478102016-12-06T22:20:27.589+01:002016-12-06T22:20:27.589+01:00I have installed both the 64bit and 32bit versions...I have installed both the 64bit and 32bit versions, but I do not see them in Visual Studio 2015 (v14.0.25431.01 Update 3)Anonymoushttps://www.blogger.com/profile/13213596864085469281noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-68483032805451974712016-12-06T21:54:49.892+01:002016-12-06T21:54:49.892+01:00Gzip report would be VERY beneficial. And compress...Gzip report would be VERY beneficial. And compression settin ()-10 for speed vs compression). Polybase in SQL 2016 and Azure SQL DW only supports gzip formatted files for extended tablesAnonymoushttps://www.blogger.com/profile/13213596864085469281noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-56672944852312945252016-08-01T13:50:58.076+02:002016-08-01T13:50:58.076+02:00Never had complaints about performance before. Are...Never had complaints about performance before. Are you using large files (can you zip them manually)? Does it finish OK eventually? Which version are you using?Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-59209947990222615112016-07-15T15:01:27.702+02:002016-07-15T15:01:27.702+02:00Installed this too on SQL Server 2012.
Its causin...Installed this too on SQL Server 2012.<br /><br />Its causing too much freezes, had to uninstall it too. Otherwise was thinking to put the DLLs on deployment server.<br /><br />Can you suggest any workaround ?Anonymoushttps://www.blogger.com/profile/18292920772907273334noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-70071135494360325882016-04-15T17:49:24.316+02:002016-04-15T17:49:24.316+02:00Thank you for reporting the bug! I have added a se...Thank you for reporting the bug! I have added a separate 64bit installer as well. You can install both of them side by side.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-17662912216015490732016-04-14T21:03:35.911+02:002016-04-14T21:03:35.911+02:00Awesome, thank you so much for assisting me with t...Awesome, thank you so much for assisting me with this Joost! I really appreciate it.skechhttps://www.blogger.com/profile/03988142639678588925noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-14139790646239381032016-04-14T20:38:18.837+02:002016-04-14T20:38:18.837+02:00I found the problem. Copy the xml files ZipTaskExt...I found the problem. Copy the xml files ZipTaskExtensions.xml and ZipTaskMapping.xml from C:\Program Files (x86)\Microsoft SQL Server\120\DTS\UpgradeMappings to C:\Program Files\Microsoft SQL Server\120\DTS\UpgradeMappings<br /><br />After that it should work. I need to adjust the installer for this, but at the moment it wont copy to both the 64bit and 32bit folder.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-71035067961768466222016-04-13T21:02:57.144+02:002016-04-13T21:02:57.144+02:00Thanks. I will investigate it this weekend and try...Thanks. I will investigate it this weekend and try to find a solution (if necessary). Thanks for the feedback.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-90219621835925717982016-04-12T22:39:12.337+02:002016-04-12T22:39:12.337+02:00Everything is on the same machine. The job only ru...Everything is on the same machine. The job only runs successfully if I set the package to run in 32-bit runtime.skechhttps://www.blogger.com/profile/03988142639678588925noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-14514707562194002662016-04-12T22:33:08.870+02:002016-04-12T22:33:08.870+02:00Is the sql agent running the packages on the same ...Is the sql agent running the packages on the same machine? Or on a different machine that doesn't have the zip task installed?Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-24941869559695991362016-04-12T22:13:50.574+02:002016-04-12T22:13:50.574+02:00Thanks for the quick reply! I'm using 'ili...Thanks for the quick reply! I'm using 'ilionx.SSIS.Tasks.ZipTaskInstaller2014V1.3'. SQL Server 2014 and Visual Studio 2013. There are no issues when I debug the SSIS solution. It only fails when trying to run the package from SQLAgent.<br /><br />Please let me know if you need any more information! I hope we can figure this one out :)skechhttps://www.blogger.com/profile/03988142639678588925noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-11066607962611438402016-04-12T21:52:16.441+02:002016-04-12T21:52:16.441+02:00Hi Skech, It should work in both 32 and 64 bit. Wh...Hi Skech, It should work in both 32 and 64 bit. Which version are you using? And which version of SSIS are you using? Then I can do some testing.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-88550308214244823702016-04-12T17:50:24.028+02:002016-04-12T17:50:24.028+02:00Hi Joost! Thanks for this great component.
I just...Hi Joost! Thanks for this great component.<br /><br />I just have a question - I'm able to run my package using SQLAgent if I run in 32-bit runtime. But when in 64-bit the job fails with this error (Cannot create a task from XML for task "ZIP create rar", type "Zip Task" due to error 0x80070057 "The parameter is incorrect").<br /><br />Do you know why this works in 32bit but not 64bit?<br /><br />Thanks<br />Geoffskechhttps://www.blogger.com/profile/03988142639678588925noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-56809491664113453942015-09-01T20:09:21.724+02:002015-09-01T20:09:21.724+02:00Yes you need to install thirdparty components on t...Yes you need to install thirdparty components on the deployment server as well!Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-39383866009927248972015-09-01T19:30:38.150+02:002015-09-01T19:30:38.150+02:00Does this task need to be installed on the deploym...Does this task need to be installed on the deployment server as well? Or is it included when a project is deployed?Houndinhttps://www.blogger.com/profile/03087920822926950548noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-924129626457023552015-08-22T12:42:17.445+02:002015-08-22T12:42:17.445+02:00No, but if I got enough request I will add GZIP su...No, but if I got enough request I will add GZIP support.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-49498169200758556132015-08-18T16:01:56.207+02:002015-08-18T16:01:56.207+02:00Does your zip task work with GZIP yet?Does your zip task work with GZIP yet?Anonymoushttps://www.blogger.com/profile/11440043679930558949noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-88645591898824610292015-02-22T08:40:20.153+01:002015-02-22T08:40:20.153+01:00Thanks! Will take that into consideration for poss...Thanks! Will take that into consideration for possible future versions.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-68929827070978643532015-02-18T06:37:40.520+01:002015-02-18T06:37:40.520+01:00Nice work on the component, thanks! As a feature, ...Nice work on the component, thanks! As a feature, could you add the option to split the final zip file into multiple files? I currently use WINZIP to manually zip a 27 GB text file into approx. 9 zip files of 665 MB each. Makes for more reliable FTP transfers but is tedious :(dtcflhttps://www.blogger.com/profile/08987760109566141610noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-73624646901736771202014-03-30T23:01:08.287+02:002014-03-30T23:01:08.287+02:00Perhaps there is some limit per file. I just zippe...Perhaps there is some limit per file. I just zipped a whole bunch of files into a 11GB zipfile without any problems. Will do some more testing in the near future...<br />Which SSIS version are you using and are you running in 64bit?Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-27992229438796646592014-03-10T18:30:06.992+01:002014-03-10T18:30:06.992+01:00I'm afraid this still exhibits the same error....I'm afraid this still exhibits the same error. Trying it with a 9.90 GB fileAnonymousnoreply@blogger.com