September 12, 2011 at 4:27 am
Hi Steve Jones
I have one folder for example Empdetails(foldername)
in that three .csv files are there that having different columns
(Ex:1) epersonal.csv file that contains three columns like [empid,efirstname,elastname])
2)eaddress.csv file that contains four columns like [ecity,edistinct,estate,ecountry]
3)eotherdetails.csv file that contains four columns iike [egender,emarried,sal]
)
I want to transfer the flat files data into Oracle destination Table Without Duplicates data
Oracle destination Table Format
EmpDetails
Empid Ename City Distinct State Country Gender Married Sal
100 Hari Hyd Hyd A.P INDIA Male Unmarried 150000
Pls help me
step by step procedure
September 12, 2011 at 8:07 am
You haven't well framed the question. Is this a one time transfer? Are they the same format? Do the names of the files change?
Setting up a one time transfer is trivial. One source, one destination, and 5 transfer tasks in a package. This gives basics: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/72493/
However if you are looking to add more to it, then someone isn't likely to build the package for you. If you have different file names, you need a for loop that scans the files in a folder. Search for that technique or ask that specific question. If you need to handle different formats, ask that.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply