So I am in the process of converting from the depreciated SQL server stages, OLDB to the ODBC Connector stage in 8.5.
My User defined SQL
SELECT 1 as BATCH_KEY, 1 as BUSINESS_DATE_KEY , FEES_CODE_KEY, 'D' as Record_Status_Code, GETDATE() as DW_DATE_MODIFIED
FROM #DW_LIB#.dbo.tDim_#TableName# a
WHERE (not exists (select 1 from #STAGE_LIB#.dbo.tStage_#TableName#
where ERP_Division_ID = a.ERP_Division_ID
and Division_ID = a.Division_ID
and Location_ID = a.Location_ID
and FEES_CODE_ID = a.FEES_CODE_ID))
and Record_Status_Code = 'A'
i get the message "Invalid Property Value Unexpected procedure reference found"
If I replace the GETDATE() function with CURRENT_TIMESTAMP it is fine.
If I try to view the data with the getdate() FUNCTION I can see the data and when I run the job everything is green.
Any Idea on how to clear this warning
ODBC Connector Stage in 8.5
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm
ODBC Connector Stage in 8.5
"Don't let the bull between you and the fence"
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm