tag:blogger.com,1999:blog-2379842053067321961.post3982058867910552258..comments2024-03-28T13:24:50.042-07:00Comments on Welcome To TechBrothersIT: How to create multiple flat files form Single SQL Server Table by Splitting Rows in SSIS Package - SSIS TutorialAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2379842053067321961.post-37394569882481505122021-12-07T10:36:32.033-08:002021-12-07T10:36:32.033-08:00Hi, Please help me in below situation.
I have a co...Hi, Please help me in below situation.<br />I have a configuration table which has all the list of table names (There are so many records in this table). By reading this configuration table, loop through each record and create a csv file for each record.<br />I want handle this in parallel processing or threading concept. How can I handle it. Each record (table) in Configuration table will have millions of records.<br /><br />Thanks In Advance.Ranjithhttps://www.blogger.com/profile/13085880098722316266noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-85194032726803774072021-10-06T17:52:05.902-07:002021-10-06T17:52:05.902-07:00how do you add a where clause to the select statem...how do you add a where clause to the select statement . it seems to allow error outAnonymoushttps://www.blogger.com/profile/09194325543535822061noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-40092540815908285942021-08-19T18:10:01.224-07:002021-08-19T18:10:01.224-07:00you can one example with filedelimiter ; or : plea...you can one example with filedelimiter ; or : please over 1 millon row partition as flat fileAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-6983279280230157682021-08-19T18:01:26.058-07:002021-08-19T18:01:26.058-07:00you can one example with filedelimiter ; or : plea...you can one example with filedelimiter ; or : pleaseAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-80893796449683501252020-10-01T11:30:09.675-07:002020-10-01T11:30:09.675-07:00How to skip/exclude the header in the output files...How to skip/exclude the header in the output files?PLShttps://www.blogger.com/profile/08227493224746513430noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-16011359826584784992020-09-17T08:32:55.286-07:002020-09-17T08:32:55.286-07:00Can I create this without using SSIS? I am running...Can I create this without using SSIS? I am running a C# windows application with SQL Server 2017 and I can not create SSIS packagesjpatrickhttps://www.blogger.com/profile/00646202187848222286noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-15395799207144213972019-07-29T08:20:16.288-07:002019-07-29T08:20:16.288-07:00Hi,
I need to export table into .csv file using th...Hi,<br />I need to export table into .csv file using the script task.But I am facing the below issues.<br />1. the column type BIT values are converted into true or false instead of 1 and 0.<br />2. the datetime column values are converted into system datetime format i.e. in the table it is like 12-7-2019 13:00:12 000 but the output file has 12/7/2019 1 PM since the server has 12 hours format.<br />Can this solved in script task? Kindly assist.nanthagopalhttps://www.blogger.com/profile/04843238132719009783noreply@blogger.com