My error is:

"The column status returned was: "The value could not be converted because of a potential loss of data."

This is when I even try doing a extract from staged...

Thank you Andy for your help.

I am going to opt-in on using SK's across my Dimensions just to get practice on using them as some dimensions might not have a...

The DW us being built as a Sales DW, the staging data is extracted from our OLTP system which is General Ledger based.

The way the business works, any new transactions...

There is no requirement to record history, basically a UPSERT/MERGE (upload record if exist, insert if it does not).

Thanks.

Thanks for the quick reply.

I am fairly new to TSQL, using SSIS seems to be the easier way and lots of youtube resources to look at to implement my load.

One...

amc, that would be great if you can post yours.

I have postponed this actually, but need to have something ready by end of next week.

I am going to give that a try, thanks.

Thanks for your reply, I will do this.

I am using Nagios to monitor our SQL Server, while it may not be comparable to the many paid products out there, it certainly does the job.

You will need check_nt...

I ran the two commands you suggested, and both msxml3.dll and msxml6.dll is registered.

Also, checking in Add or Remove Programs I found the following:

MSXML 6.0 Parser

SQLXML4

The issue is still there...

I tried your suggested trick:

regsvr32 msxml6.dll

Still no go, I think in this case there are tables that are missing, which should have been created/updated when SP2 was applied (long before...

How could I check the version of the resource database?

Thanks..

/bump ?

Is there a way to restore the tables that did not seem to get "created/updated" when SP2 was applied to SQL Server without breaking anything?

Anyone have any idea?

I should also mention that tin the EDI_DATA table, there are columns that store Binary Data (documents).