How to fetch 3 differente file in single source ?
Thanks for reply,Source file: 1. Excel 2.CSV 3. Flatfile, Destination: SQL Server but database fileds are same. Ranganathan.Palanisamy
February 12th, 2011 8:50pm

Thanks for reply,Source file : 1. Excel 2.CSV 3. Flatfile, Destination : SQL Server but database fileds are same . Ranganathan.Palanisamy How about fields in files? are there same in all files?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2011 8:55pm

Hi Experts, How to fetch 3 differente file single source(Excel,csv,flatfile ect..)? i wanted to process 3 differente source,three differente table assignment as well .. share some idea how to reslove this problem? ThanksRanganathan.Palanisamy
February 12th, 2011 9:29pm

Hi Sudeep., Thanks for reply.,Don't want to merge any files, my requirement is : i wanted simpify the SSIS application Example xyz have a company,they have differente vendor like A,B,C ,Like A have diffente folder to drop the file as same as B and C as well as file format also different(Excel,csv,flatfile) like this.,i wanted to know develop single ssis package all the vendor. i wanted to know how to approach this problem ? please suggest effective way to do that ThanksRanganathan.Palanisamy
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2011 9:34pm

If I understand correctly you want to merge the data of 3 different files and then tranform that. Because what your heading to the thread says is not possible. How do you want to combine the data? Union or Merge? ie. if ur 3 source have 10 record each will your intended 1 source contain 10 rows or 30 rows?My Blog | Ask Me
February 12th, 2011 9:37pm

Example xyz have a company,they have differente vendor like A,B,C ,Like A have diffente folder to drop the file as same as B and C as well as file format also different(Excel,csv,flatfile) like this.,i wanted to know develop single ssis package all the vendor. You can develop specialized (child) packages and combine them with master package. Related link: Creating the Master Package It’s come to that point where all of the SSIS packages for the data warehouse are complete. As other searches have pointed out, there are multiple ways to glue everything together. Coming from a DataStage or Informatica background, however, I prefer the creation of a “master package”. This package is strictly a control flow that utilizes several ‘Execute Package’ tasks. http://dichotic.wordpress.com/2006/10/30/creating-the-master-package/Kalman Toth, Business Intelligence Developer; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2011 10:01pm

thanks for reply., No differente fields for every one.,But we going to map same destionation table Thanks Ranganathan.Palanisamy
February 12th, 2011 10:02pm

As your source differ ( excel, flat file ) , then you need to have two different sources , so you need to have two different mappings, then you can handle it in control flow to find out source file type and redirect flow to suitable data flow task. Does it make sense to you? if all your source files was in same format ( all flat file for example ) then you could simply use single source/destination / mapping, and use it in a foreach loop. but your situation is not this one. http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2011 10:07pm

Hi Reza Raad., Thanks for great suggestion.As per your suggestion we are going to design single package. Thanks for once again for great suggestion. Thanks Ranganathan.Palanisamy
February 12th, 2011 10:11pm

We need more info, like the frequency of the files, ow you pick the files, are the destination the same? The file types are different but are the columns same in all the files types(excel, txt, csv..)My Blog | Ask Me
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2011 10:14pm

ok thanks for reply.,all the file destination is the same.But vendor coulms are differente we need to map Thanks Ranganathan.Palanisamy
February 12th, 2011 10:31pm

If structure of data in files are different, then you can not use data flow task , because data flow task doesn't support dynamic metadata. But you can use a foreach loop and an execute sql task which executes BCP command dynamically, But I'm not exactly clear on this yet, tell me what is source ? and what is destination ? (sql server , flat file? ....?)http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2011 10:42pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics