I have a query which gets the data from msdb.dbo.sysjobactivity table from XYZ server and loads into a staging table in BBC server.
But while running the query i am getting error :Error converting datatype DBTYPE_DBTIMESTAMP to datetime.
My stging table in BBC server has DATETIME as datatype for all date related columns in sysjobactivity table.But i dont know what datatype is in XYZ server's msdb.dbo.sysjobactivity table.I think all msdb databases and related tables should have same datatypes
in all the servers .
Can anyone tell me how to convert DBTYPE_DBTIMESTAMP to DATETIME .So that i can load my staging table after converting dbtimestamp to datetime.
Thanks in Advance!!
View Complete Post