DSXchange

Yes. W.r.t. that one col.

You can use normal transform to check the field count to do this.

Anyhow, as you have asked for Ray's help, I will leave it to him to answer.

Make sure the format is yyyy/mm/dd. Also check you have 4 digit year.

You can do a sort with stage variable check or use agg if the data volume is low.

There are many other ways and everything depends on detailed analysis of what you are doing and what you wish to achieve.

To keep it simple, you can create a table in your db and populate it with the value from hash-file. This will assist you in writing an SQL linking this table from hash-file and you will not need any parameter to be passed.

You can sort the source to appear in order of history and use stage variables to achieve your desired result.

As your requirement appears to be incomplete at this moment, you can better decide the logic you wish to follow with the skeleton method mentioned above.

Check the number of columns in your source file. Maybe your source file did not change to 49 cols.

Did the installation ran out of space of was it the project due to jobs.

If it is the project, then take an export, recreate it in the next place and import.

You need to create a stand-alone job that reads the value from the hash-file and returns as the status. The next job can then obtain this value and include this as a parameter in the SQL.

What error message you are receiving?

Did you check whether the link is NLS enabled?

The access violation implies permission issue with the stage. You need to provide more info on what you are doing and what error message and at what stage.

You will need to include the 2 columns in your column defn tab.

And also include an upper cap for the extract period so to know where to start next time.

Check the SMTP server name supplied as part of the notification stage.

You can build your custom operator to do it.