tag:blogger.com,1999:blog-2379842053067321961.post620012320178117536..comments2024-03-29T02:42:58.208-07:00Comments on Welcome To TechBrothersIT: How to Convert CSV/Text Files to Excel Files in SSIS Package by using Script Task - SSIS TutorialAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-2379842053067321961.post-21701520865046005312023-02-20T07:08:43.450-08:002023-02-20T07:08:43.450-08:00it is not converting to Excel when we have 2 same ...it is not converting to Excel when we have 2 same column names in csv file and it is giving error as column already exists.. please help me.Vinodhttps://www.blogger.com/profile/09389378324625198657noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-60338053891200319522023-02-20T07:07:27.583-08:002023-02-20T07:07:27.583-08:00This comment has been removed by the author.Vinodhttps://www.blogger.com/profile/09389378324625198657noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-79132679487346605082022-04-20T14:38:59.675-07:002022-04-20T14:38:59.675-07:00Great post by the great author, it is very massive...Great post by the great author, it is very massive and informative about <a href="https://freewebtoolz.com/image-converter" rel="nofollow"><b>Image Converter Online Free</b></a> but still preaches the way to sounds like that it has some beautiful thoughts described so I really appreciate this post .freewebtoolzhttps://www.blogger.com/profile/08977491436479213757noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-62618485142296038812022-03-31T15:46:29.917-07:002022-03-31T15:46:29.917-07:00I'm really impressed with your writing skills,...I'm really impressed with your writing skills, as smart as the structure of your weblog.<br /><a href="https://ascrack.org/magix-video-pro-crack/" rel="nofollow">MAGIX Video Pro Crack</a><br /><a href="https://ascrack.org/movavi-video-editor-plus-crack/" rel="nofollow">Movavi Video Editor Plus Crack</a><br /><a href="https://ascrack.org/adobe-incopy-crack/" rel="nofollow">Adobe InCopy Crack</a><br /><a href="https://ascrack.org/" rel="nofollow">ascrack.org</a>ascrack.orghttps://www.blogger.com/profile/18237512218655321811noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-41325128978582117382022-02-13T16:59:12.569-08:002022-02-13T16:59:12.569-08:00I am very impressed with your post because this po...I am very impressed with your post because this post is very beneficial for me and provide a new knowledge…<br /><a href="https://crackmaker.net/advanced-xls-converter-crack/" rel="nofollow">advanced-xls-converter-crack</a>Fraz Khanhttps://www.blogger.com/profile/11189541745878511366noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-69498524556929228622022-02-13T03:15:22.539-08:002022-02-13T03:15:22.539-08:00Amazing blog! I really like the way you explained ...Amazing blog! I really like the way you explained such information about this post with us. And blog is really helpful for us this website<br /><a href="https://crackmaker.net/blackmagic-design-fusion-studio-crack/" rel="nofollow">blackmagic-design-fusion-studio-crack</a>Fraz Khanhttps://www.blogger.com/profile/11189541745878511366noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-64989651417848916452021-08-13T21:37:17.023-07:002021-08-13T21:37:17.023-07:00Happy for know your article. As you wish, i have d...Happy for know your article. As you wish, i have <a href="https://download-lagu.online" rel="nofollow">download lagu online</a> music mp3. Can you review that?momohttps://www.blogger.com/profile/17964842562436857931noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-65085211030439608092021-06-22T09:12:15.144-07:002021-06-22T09:12:15.144-07:00can you figure this out using a text qualifier. if...can you figure this out using a text qualifier. if you have a single quote in a text field then this will fail.Blade2https://www.blogger.com/profile/16178346106741500115noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-62247456232638822822021-04-06T12:09:49.202-07:002021-04-06T12:09:49.202-07:00Anyone have any problems with the script only proc...Anyone have any problems with the script only processing 50 files? I even put the script task in a For Each container and only converts 50 files.Carrie-Annehttps://www.blogger.com/profile/11901095451735270885noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-77119274079306355022021-03-01T21:20:34.635-08:002021-03-01T21:20:34.635-08:00Hello Sir, am using your example to convert my tex...Hello Sir, am using your example to convert my text files to Excel files, my text files are pipe delimited. However in my text files for one single row there are some values which are null (| |) this causing an error when running the package. Also I have decimal numbers in the text files this too causing errors. And finally I have the word "EOF" at the end of the text file to indicate End of file which is causing errors too. Can you please advise how to solve these 3 problems please.Yaasiinhttps://www.blogger.com/profile/01249332453083908488noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-44177896291740321882020-11-02T13:42:42.588-08:002020-11-02T13:42:42.588-08:00Looks like good code...outside of the Excel 12 har...Looks like good code...outside of the Excel 12 hardcode in the middle of it.UzzyBhttps://www.blogger.com/profile/17928140466965097017noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-33316303011879521062020-10-14T03:56:14.512-07:002020-10-14T03:56:14.512-07:00its very helpfull and how convert the xlsb to xlsx...its very helpfull and how convert the xlsb to xlsx file and sheet name should be constanmt<br />Ashokhttps://www.blogger.com/profile/06847304588128166802noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-15742440516924026062020-09-04T16:29:09.937-07:002020-09-04T16:29:09.937-07:00I have notice that..that orignal file which this S...I have notice that..that orignal file which this SSIS package is creating is showing (.XLSX) extension in capital letters...and when i "SAVE AS" it , the extension gets small letters. please advise what do i change in the package to get small letter xlsx.Anonymoushttps://www.blogger.com/profile/06172764286779608706noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-28788592229055419262020-09-04T16:15:29.179-07:002020-09-04T16:15:29.179-07:00I have crated excel files. they are accessible in ...I have crated excel files. they are accessible in excel 2010 but when I am trying to upload it in Marketplace website it is not recognizing the format. I have checked it is xlsx. <br /><br />When i open and "SAVE AS" it and try to upload, it gets successfully upload. Can anyone tell me what i am missing here?Anonymoushttps://www.blogger.com/profile/06172764286779608706noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-91373686725894066162020-04-02T11:36:11.196-07:002020-04-02T11:36:11.196-07:00Looking for something a little closer to 100% perf...Looking for something a little closer to 100% perfect <a href="https://transcribear.com" rel="nofollow">video to text</a> conversion? Our standard transcription service is still a cost-effective way to convert video to text and provides specialised transcription services. Don't forget to check today!SimonaGabrielehttps://www.blogger.com/profile/09971691759649374972noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-9752491558004996152020-01-12T01:04:16.076-08:002020-01-12T01:04:16.076-08:00So you can play swf record on windows with Adobe F...So you can play swf record on windows with Adobe Flash Player effectively, however it is a hard thing to watch them on macintosh, similar to the folks cry: <br /><a href="https://anyconv.com/" rel="nofollow">anyconv.com</a><br />marksonhttps://www.blogger.com/profile/03798322600734426599noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-80907851397916921432019-09-27T05:20:25.396-07:002019-09-27T05:20:25.396-07:00Hi, This script is brilliant and works very well, ...Hi, This script is brilliant and works very well, thank you very much for sharing this.<br /><br />One question I have is what do I do if the csv file i'm trying to convert doesn't have a delimiter?<br />I cannot leave the variable blank as the code errors out, do you have any suggestions?kellett23https://www.blogger.com/profile/05211790461829706463noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-30037477558150278522019-03-27T03:24:36.004-07:002019-03-27T03:24:36.004-07:00Hello Aamir,
Good Morning Thanks for the SSIS vid...Hello Aamir,<br /><br />Good Morning Thanks for the SSIS videos with great knowledge to learn and implement in our projects. I have few queries in regards to one of the SSIS Video (Converting CSV File to Excel using Script Task).<br /><br />I have a scenario where their is huge CSV File with data in some fields and with no data in some other fields, and i see that the script that you have provided has limitations and in regards to my requirement i need to add few more lines of code in the script.<br /><br />As i have no knowledge on C Sharp, i am facing difficulty in making those changes. It would be a great help if you could help with those kind of videos as well.<br /><br />Anonymoushttps://www.blogger.com/profile/17756699636243906853noreply@blogger.com