tag:blogger.com,1999:blog-2379842053067321961.post1120035784969512790..comments2024-03-28T05:21:44.049-07:00Comments on Welcome To TechBrothersIT: How to load Data from Multiple Text / CSV Files to SQL Server Table with File Name by using Script Task in SSIS Package - SSIS TutorialAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-2379842053067321961.post-86072583919105323772022-04-19T22:06:38.636-07:002022-04-19T22:06:38.636-07:00Thank you so much for posting this.
Could you ple...Thank you so much for posting this.<br /><br />Could you please let me know how to fix this error:<br />Unclosed quotation mark after the character string <br /><br />The script works fine but it give that error at this record because it has the single quote ' in the address field:<br /><br />220615550139319,999,"WILLIAM","SMITH","34522498","8782","P","180 BURKETT'S FERRY RD","HAZELHURST",20220301,20220302,"GA","31539",0<br /><br />Thank you in advance for your help!<br />Quynhhttps://www.blogger.com/profile/10833717981735688968noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-1197106401352360402020-11-15T12:37:58.867-08:002020-11-15T12:37:58.867-08:00I am thankful to you for sharing this plethora of ...I am thankful to you for sharing this plethora of useful information. I found this resource utmost beneficial for me. Thanks a lot for hard work. <a href="https://www.viki.com/users/legacydataarchiving_181/about" rel="nofollow">Legacy Data Archiving System</a><br />Alexfrahttps://www.blogger.com/profile/18362297960327329544noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-75432745674762769832020-10-28T14:37:03.179-07:002020-10-28T14:37:03.179-07:00Hi, my csv file looks like the following
Vehicle L...Hi, my csv file looks like the following<br />Vehicle Loan,"TERIL NELSON",'215300','27-OCT-2020 15:22:12','27-OCT-20','MOBILE'<br /><br />when I clean it up manually like following with just the comma separator, the script works perfectly.<br />Vehicle Loan,TERIL NELSON,215300,27-OCT-2020 15:22:12,27-OCT-20,MOBILE<br /><br />I think this line needs some fixing for my csv files to load, can someone please help?<br />query += line.Replace(FileDelimiter, "','") + "','" + fileName + "')";<br /><br />Thanks,<br />FaizDBAhttps://www.blogger.com/profile/08067846002486606761noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-42858128381341874282020-04-24T11:05:10.119-07:002020-04-24T11:05:10.119-07:00How can this be done quicker? currently loading 1m...How can this be done quicker? currently loading 1mil rows an hour....way too slow.John de Kockhttps://www.blogger.com/profile/08162493068728677283noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-14256659400135066372020-04-15T23:01:39.173-07:002020-04-15T23:01:39.173-07:00Hello, I am trying to do Multiple CSV to multiple ...Hello, I am trying to do Multiple CSV to multiple tables in SQL using c# script. But getting issues with datatypes , espically dattime issues, CSV datetime filed is of type string and in SQL its datetime so unable to convert string to datetime dynamic. Help me here please<br />Shwetahttps://www.blogger.com/profile/13346350722432166915noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-4149565198431461292020-03-31T14:25:02.946-07:002020-03-31T14:25:02.946-07:00Hi, Thank you so much for providing the code to lo...Hi, Thank you so much for providing the code to load multiple flat files to SQL table. We are having the same use case in our organization. This is so helpful. I have tried using your process but in the sql table I am getting double quotes for each column. I know can use text qualifier to get rid of this if we use flat file task. How can we achieve this in script task. Could you please let me know. <br /><br />Appreciate your help.<br /><br />Thanks in advance.Divya Avirnenihttps://www.blogger.com/profile/02293041642035045739noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-25993198420936160312019-11-22T05:57:10.914-08:002019-11-22T05:57:10.914-08:00I tried with blank but package is failing.
I tried with blank but package is failing.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-60782161395364936312019-11-22T05:55:22.831-08:002019-11-22T05:55:22.831-08:00Thanks for uploading these videos and sharing know...Thanks for uploading these videos and sharing knowledge ! They are very descriptive and helpful. It worked for me for CSV files but i am trying to make them work for excel files. .XLS is the extension. What would be my file delimiter in that case ? Please suggest.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-11818501217557754852019-07-19T11:23:42.108-07:002019-07-19T11:23:42.108-07:00Hi, I keep getting the following error when I atte...Hi, I keep getting the following error when I attempt to run this using SQL Authentication<br /><br />ExecuteNonQuery: Connection property has not been initialized.<br /><br /><br />Any thoughts on how to fix this?Anonymoushttps://www.blogger.com/profile/04093633679337247429noreply@blogger.com