MohitPandit
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER