tag:blogger.com,1999:blog-2379842053067321961.post2227847086566520410..comments2024-03-28T05:21:44.049-07:00Comments on Welcome To TechBrothersIT: How to create Text or CSV File Dynamically from Table or View in SSIS Package by using Script Task - SSIS TutorialAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2379842053067321961.post-77022231125234339672021-03-05T07:17:39.066-08:002021-03-05T07:17:39.066-08:00add this after declaring your variables
FileDelim...add this after declaring your variables<br /><br />FileDelimiter = FileDelimiter.Replace("\\t", "\t");chuckhttps://www.blogger.com/profile/11674430693835796885noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-78947212017650350642020-10-14T04:18:28.347-07:002020-10-14T04:18:28.347-07:00Hi, great tutorial.
I would be interested in chang...Hi, great tutorial.<br />I would be interested in changing the dafult date format and length of text fields as instead of DATE your script seem to export datetime and instead of cut strings it exports full lenght strings.<br />Any suggestions to that?visitorhttps://www.blogger.com/profile/11014662671854860778noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-33104122383024864672020-05-15T06:52:24.452-07:002020-05-15T06:52:24.452-07:00I love you guys. I've learned a bunch from you...I love you guys. I've learned a bunch from you. On this particular tutorial I am trying to create a tab delimited text file. What would the delimiter be in the variable? I am then reloading these files in a system through SSIS. I can get the .csv file to work but not the tab delimited text file. Any ideas? I thought the delimiter would be \t but that doesn't work.Blade2https://www.blogger.com/profile/16178346106741500115noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-80624353715807139922020-04-16T11:11:04.382-07:002020-04-16T11:11:04.382-07:00This is amazing! However, i need to wright 200m+ r...This is amazing! However, i need to wright 200m+ rows to the file.....can i do it in batches?John de Kockhttps://www.blogger.com/profile/08162493068728677283noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-50745728846332442622019-07-02T18:08:49.992-07:002019-07-02T18:08:49.992-07:00Great tutorial. Thank you for sharingGreat tutorial. Thank you for sharingJulian Castiblancohttps://www.blogger.com/profile/05849631392361000353noreply@blogger.com