Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 891
  • Last Modified:

SSIS: problem with column mapping .csv and database table

Hello,

I've a CSV file. For e.g, it contains three columns (RollNo, Name, Address).

I opened SSIS design and took data flow task --> Flat File Source + OLE DB Destination and mapped CSV file columns with database. Then run the package, it runs successfully.

After that, I open CSV file again and move column position like Name from 2nd position to Address and Address 3rd position to Name position. Of course, along with data as well.

Now, if I run again package then package runs successfully. But, column Address data goes to Name column and Name column data goes to Address column in database.

But if it is the case then why we need mapping while design?

Could you please look into it on urgent basis because for a requirement of a project; columns can be placed anywhere?


Best Regards,
Mohit Pandit
0
MohitPandit
Asked:
MohitPandit
3 Solutions
 
TempDBACommented:
You have moved the data in the csv file with the column name and hoping that you mapped the column while designing the package, it should take care of that right. But it doesn't work like that. You have to remap it in the package because though what you see is a label, the mapping happens as column2, column3 wise. So, it won't consider if you just modify it in csv file.
0
 
selva_konguCommented:
0
 
Alpesh PatelAssistant ConsultantCommented:
You have to remap or just open that flat file source and update.
0
 
MohitPanditAuthor Commented:
thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now