CODEWITHSUNDEEP
ssis
Zia Ur Rahman
Zia Ur Rahman

Reputation: 3

Loading Data in OLB DB from Flat file in SSIS

I want to load data from flat file to OLB database Destination in SSIS, but before loading in Source, I want to convert the data...

The problem is that I don't know how to do it. For example:

Data: 1,XYZ,03XX-XXXXXX,street number town number, road city

Now, I want to remove road cite, after town number before loading in a flat file destination.

Upvotes: 0

Views: 71

Answers (2)

Drishya1
Drishya1

Reputation: 269

If the data in your text file is coming in as in screenshot1 and you want your output to look like the one in screenshot2 then uncheck the column in which you have your road city data as in screenshot3.

Screenshot of text file

Screenshot of Desired Output

enter image description here

Upvotes: 1

Tab Alleman
Tab Alleman

Reputation: 31785

Use a derived column transformation, and use an expression to create a new column that removes the comma that you want to remove.

Then in your OLE DB destination, map the new column instead of the old one to your destination column.

Upvotes: 1

Related Questions