Hi, Source is sql server database. read the data from one table. I want to transfer the data into multiple text files at a time (Destination). how to generate multiple text files in SSIS 2005. can u give me examples on this.

The Flat File Destination can be used to create Flat Files. Other than that I can't give you a more specific answer because you haven't asked a very specific question. What logic are you goig to use to split the data into multiple files? Please provide more detail if you want people to spend their time helping you. Regardshttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi Kumar, Please check the MATTHEW's blog for your current requirement. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

In addtion to the above, you can use the Conditional Split Transformation to route your data into multiple destinations: http://beyondrelational.com/blogs/divya/archive/2009/09/26/data-flow-transformations-in-ssis.aspx Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM

If you would like to load the same data in two different files then just use a multicast and load the data to multiple files.Sarvan