tag:blogger.com,1999:blog-2303058199815958946.post336955853040802924..comments2024-03-28T10:36:35.016+01:00Comments on Microsoft SQL Server Integration Services: How to skip the trailer recordsJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2303058199815958946.post-6905571900407274992017-05-22T08:42:09.189+02:002017-05-22T08:42:09.189+02:00This worked wonders. Thank you so much!This worked wonders. Thank you so much!andezzathttps://www.blogger.com/profile/03744265697973066828noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-22257665828679365182013-09-24T07:32:47.900+02:002013-09-24T07:32:47.900+02:00Just read the file as in the solutions above and a...Just read the file as in the solutions above and add a Flat File destination.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-45200624981748659802013-09-24T07:20:49.152+02:002013-09-24T07:20:49.152+02:00How to remove header and footer row in flat file a...How to remove header and footer row in flat file and move the flat file to another location without having that header and footer rows .Sandeephttps://www.blogger.com/profile/12772094433891099399noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-22907006976376374722013-04-05T22:55:49.054+02:002013-04-05T22:55:49.054+02:00Hi Thanks for leaving a message! Please try refres...Hi Thanks for leaving a message! Please try refreshing the page... can see missing images. The image a 4) is <a href="http://3.bp.blogspot.com/-VEA4tmJdQJo/TV5_no0jqXI/AAAAAAAAAOA/GVV3Z1BcJWc/s320/Footer5.jpg" rel="nofollow">http://3.bp.blogspot.com/-VEA4tmJdQJo/TV5_no0jqXI/AAAAAAAAAOA/GVV3Z1BcJWc/s320/Footer5.jpg</a>. If it's still not working then please contact me via the Contact Me in the menu.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-19091348334300418712013-04-05T22:48:43.744+02:002013-04-05T22:48:43.744+02:00Some of the images are missing - in particular 4) ...Some of the images are missing - in particular 4) Script Component. I hope you can re-add it. Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-19343292121245726362012-03-20T22:53:43.358+01:002012-03-20T22:53:43.358+01:00I'm afraid that isn't possible with SSIS. ...I'm afraid that isn't possible with SSIS. But there are some cleaver .Net Scripts available (which I haven't tested myself). For example: http://stackoverflow.com/questions/398378/get-last-10-lines-of-very-large-text-file-10gb-c-sharp<br />http://stackoverflow.com/questions/4619735/how-to-read-last-n-lines-of-log-fileJoost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-16501293579288468632012-03-20T00:44:35.275+01:002012-03-20T00:44:35.275+01:00Hi, this looks great. I have a large text file and...Hi, this looks great. I have a large text file and need to read only the footer only. Is there a quick way (without reading all the records) of reading this?Anonymousnoreply@blogger.com