Hi All,
I need to default a value for a particular column into the target table based on the job status
As part of the job design I need to populate only this field,No other fields were not required as its just the status.
eg: 'The latest data was not available in the system'
Help me how to proceed to populate this single field hardcoded value into the target.
Kind Regards
Default value problem
Moderators: chulett, rschirm, roy
Just... update it.
You'll need to supply something in the way of 'key' information so the job knows what record to update. What part are you having problems with? What job status are we discussing here? How will you check / pass it?
Do you have anything like a specific question?
![Confused :?](./images/smilies/icon_confused.gif)
Do you have anything like a specific question?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 30
- Joined: Tue Feb 19, 2008 11:02 pm
Hi,
I need to check the file status using 'Wait for file activity'
If the file is available ..I will process the logic.
If the file is not available I nedd to insert a record into the error table by logging 'File is not available use previous day's data'
for that I need to desing the job without source...just to hard code this message.
Kind Regards
I need to check the file status using 'Wait for file activity'
If the file is available ..I will process the logic.
If the file is not available I nedd to insert a record into the error table by logging 'File is not available use previous day's data'
for that I need to desing the job without source...just to hard code this message.
Kind Regards
-
- Participant
- Posts: 30
- Joined: Tue Feb 19, 2008 11:02 pm
Hi,
I need to check the file status using 'Wait for file activity'
If the file is available ..I will process the logic.
If the file is not available I nedd to insert a record into the error table by logging 'File is not available use previous day's data'
for that I need to desing the job without source...just to hard code this message.
Kind Regards
I need to check the file status using 'Wait for file activity'
If the file is available ..I will process the logic.
If the file is not available I nedd to insert a record into the error table by logging 'File is not available use previous day's data'
for that I need to desing the job without source...just to hard code this message.
Kind Regards
-
- Participant
- Posts: 30
- Joined: Tue Feb 19, 2008 11:02 pm
-
- Participant
- Posts: 30
- Joined: Tue Feb 19, 2008 11:02 pm