We want to create an SSIS package to transfer data from one source to multiple destinations we need to split data using the queries while transferring data.

Is the data source SQL. If yes you can have multiple data flow tasks, each with a ole db source with a sql query. The sql query will pull out data of your interest and then you can push it into the destination of your choice. If its a non sql source, you can use conditional split tranformation to divide the data set based on conditions and then push the data into the multiple destinations.http://btsbee.wordpress.com/

Hi Thanks a lot.. Our source is SQL. we are having two sql queries based on these queries we need to transfer the data to the destination. how to include these queries and transfer the data. Please provide samples Im new to SSIS packages.

Check this link. If you look at illustration number 5,6 the author has configured an Ole DB source with a sql query in it. The SQL query is filtering out the rows of interest using a where clause. Follow msdn link to learn about OLE DB souce in general. http://btsbee.wordpress.com/