DSXchange

My educated guess is Knowledge Transfer.

From OP's post my understanding was the password was hardcoded within the ODBC stage and not at the job parameter level. So not sure if doing an echo #Password# would work in this case.

natashab wrote:Then will not the same customer having 2 incoming records with the amount deposited and amount withdrawn details be looked up and considered as 2 new records?

No. The record will/should be treated as an update record. Again that depends on the data model you have.

You can always place a Transformer stage between the reference table and the LookUp stage and handle the trim in the Transformer stage.

Were you able to verify the data in Input 3 and Input 4 to make sure the records with key values 1, a and 2, b are present? Have you hash partitioned the data before sorting?

I am not sure how you got the output records in your examples with the data you have provided? What are the conditions you are trying to meet?

Couple of Options:

1. You can use a LookUp Stage and use the data in the target table as a reference to find the updates and inserts.
2. You can use Change Capture Stage to compare your source data between two consecutive runs and identify the inserts and updates.

I tried sleeping on this. To me it appears as if you need to swap your reference and source stages. And there should be some kind of a business requirement that allows you to pick up the required record.

You can still map the five fields to the Sequential File stage from the Transformer. In the transformer stage make sure you default all the column derivations to empty strings(''). Make sure you set the First line is Column Names property to True and at the end of the job you will have an empty file...

Somehow, no matter how many times I read your post I am having trouble understanding your requirement. Can you be more clear on how your final output should look? How many records do you expect to see based upon the example you have provided?

Sending multiple attachments from a single Email Notification Activity is not supported.

Even after all these posts, I am still at loss about what exactly you are looking for . A solution has been provided on how to increment the Year. You need to be more specific about your requirement if what had already been discussed is not helping you.

Have you tried User defined SQL?

It happens when you have hanging/old client sessions in the background. You will need to kill those connections.

See if this helps

How far into the future do you have to create these set of files apart from handling the leap year?