tag:blogger.com,1999:blog-6357505892638015674.post2783958430905244032..comments2023-12-11T22:43:08.539-08:00Comments on Welcome to SQLServer MVP Blog: Migrating Data from multiple source to single destinationUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6357505892638015674.post-89242239263395958542009-05-12T01:05:00.000-07:002009-05-12T01:05:00.000-07:00Its too simple Abdul,
Put three sources and thr...Its too simple Abdul,<br /><br /> Put three sources and three destinations and you can point out as per my example.<br /><br />It will work fine. You can use only one dataflow task to achieve it.<br /><br />Thanks and Regards,<br />Venkatesan Prabu .JVenkatesan Prabuhttps://www.blogger.com/profile/02685812384505488301noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-2194118520581440362009-05-09T21:21:00.000-07:002009-05-09T21:21:00.000-07:00Hi VP,
I want to lload multiple source text files...Hi VP,<br /><br />I want to lload multiple source text files to corresponding Destination tables using just SSIS. I am not a .Net guy, so do not want to use Script Transformation.<br /><br />Example,<br /><br />I have 3 text files namely:<br />File_1.txt<br />File_2.txt, and File_3.txt.<br /><br />I want to load these files to their corresponding table namely:<br />Table_1, Table_2, and Table_3.<br /><br />I want to use it without using any .Net Code.<br /><br />Please, help me doing this. I can be reached at: amoyeed@gmail.com.<br /><br />Thanks,<br />Abdul MoyeedAbdulhttps://www.blogger.com/profile/18097190285289397633noreply@blogger.com