April 27, 2011 at 6:26 am
Dear Friends,
My source is Flatfile [ txt and csv ]
Destination is table [ The format and datatype wil be the same as in source]
Kindly let me know the steps for doing this.
My source txt - will not have any delimeters.
My source csv - doesnot have any column names. it is a comma seperated file.
Kindly let me know how to proceed further
thanks in advance.
April 27, 2011 at 7:20 am
My suggesstion would be to use the import Data wizard and import the data one time. When you run through the package you can use the option to save as an SSIS. Then spend some time looking into the SSIS and do research to understand what it setup. If you have specific questions at that point we will see what we can do.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 27, 2011 at 11:18 pm
my text file is not in formatted way. see below example.
R001D0345003214555 Ambika, Mahesh A
in the above sample,
R001 - region
D0345 - district
003214555 Ambika, Mahesh A - employee cde with his name.
so first i want to split this respective.
and if i use flat file wizards, and give delimeter, still im not getting this data in correct format.
please help me to get the above data in right format in to DB table
April 28, 2011 at 1:42 am
kiruthika.naren (4/27/2011)
my text file is not in formatted way. see below example.R001D0345003214555 Ambika, Mahesh A
in the above sample,
R001 - region
D0345 - district
003214555 Ambika, Mahesh A - employee cde with his name.
so first i want to split this respective.
and if i use flat file wizards, and give delimeter, still im not getting this data in correct format.
please help me to get the above data in right format in to DB table
Your file is 'not formatted in any way'! Well I'm assuming that the first 4 characters will always be the region, the next 5 characters will always be the district etc.... if this is the case then....
Use the Import wizard and once you select the flat file source and your file name, select the 'ragged right' format. Then go to the columns page and specify each column by creating markers. Check also the column widths from the advanced page and ideally give meaningfull names to your columns. Once you define your columns, go to the preview page and check your output.
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply