Not sure if anyone can advise on a SSIS package that I have that joins 2 CSV files together.
In The first one I have a Custid of 11003349270
In the second file I have Custid of 3349270
The second file will always be like this the last 7 digits of the first file custid.
In my SSIS I have them with 2 flat file sources, 2 sorts which then merge join and then creates a flat file destination. It is falling on the 2 custid codes being different. I have no other way to match the two files other than the custid,
Have you any idea how I can truncate the File1 CustID field to the last 7 digits in the SSIS package
Any ideas please. Thanks
In The first one I have a Custid of 11003349270
In the second file I have Custid of 3349270
The second file will always be like this the last 7 digits of the first file custid.
In my SSIS I have them with 2 flat file sources, 2 sorts which then merge join and then creates a flat file destination. It is falling on the 2 custid codes being different. I have no other way to match the two files other than the custid,
Have you any idea how I can truncate the File1 CustID field to the last 7 digits in the SSIS package
Any ideas please. Thanks