July 12, 2009 at 10:31 am
i need to dump the flat file to a table and the flat file is in this format
~100~test~20-4-2009~
when i do a delimited option with ~ i get like 5 columns in the column mapping
first colum is blank
second column is 100
third is test
fourth 20-4-2009
fifth blank
i want only three columns
July 12, 2009 at 10:59 am
Hello,
There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
July 12, 2009 at 12:15 pm
Thanks it worked.
July 12, 2009 at 6:01 pm
John Marsh (7/12/2009)
Hello,There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.
Regards,
John Marsh
🙂 There is a slightly more elegant solution. The problem with this method is that redundant data is fired through the pipeline. To avoid this, edit the flat file source and deselect the unwanted columns ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply