February 8, 2018 at 7:24 am
Hi all,
I have two issues and i am not sure why they are occurring. I am running SQL 2016 enterprise on Azure. I believe that the issues relate to caching of some sort. The summary is; I have an ETL project, there are changes done to the project. I rebuild the project. When the job runs it appears that the changes do not get implemented. I can confirm everything is functional because I execute the job in SSIS and all works well. I have noticed this with two parts. 1) SQLServer Agent Error (Reference Environment ID = NULL) (StackOverFlow mentions the fix is the delete and recreate the job). 2) SCD type 2 that does not pickup changes.
Has anyone experienced these issues?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply