Hi , You can increase the buffer row size and buffer size of package.This can be achived by changing the properties DefaultBufferMaxSize and DefaultBufferMaxRows. Please look into the following link for more details:http://www.mssqltips.com/sqlservertip/1867/sql-server-integration-services-ssis-performance-best-practices/*Regards* *Samay Shrivastava* *Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*

Hi , You can increase the buffer row size and buffer size of package.This can be achived by changing the properties DefaultBufferMaxSize and DefaultBufferMaxRows. Please look into the following link for more details:http://www.mssqltips.com/sqlservertip/1867/sql-server-integration-services-ssis-performance-best-practices/*Regards* *Samay Shrivastava* *Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*

I'm extracting 6 months data(approximately 1 crore records) using SSIS package,I executed my pkg but the records flow is not started after half an hour also,but the data flow task showing yellow color only,please help me how to load batch of records into csv file from sql server?Naresh

Have you a where clause in your source? Maybe this one is to slow. btw: I don't know, how many rows 1 crore is, please use english names for the numbers

Can you do a preview of the data in the source component? Do you use a query? Are there any indexes on the table(s)?MCTS, MCITP - Please mark posts as answered where appropriate.

1 crore = 10 billion records yes my query contains where clause, group by clause and five inner joins and one left join, before this extraction I took 10 days sample data(5,00,000) that time pkg took just 11 minutes to complete.Naresh

sorry 1 crore = 10 Million not BillionNaresh

query timeout expired error is coming when i clicked on preview.Naresh

Are you sure there is a good connection to the database? If you run the query in management studio, how long does it take to return rows? You can set the time-out option on the OLE DB connection to a higher value.MCTS, MCITP - Please mark posts as answered where appropriate.

thanks for ur help guys,I need to wait for some time to complete the pkg,Definitely it takes time to finish.Naresh