Hi Mike,

thanks, but if this is the only way to do that, I have to de-install the Attunity stuff.

This would cause me to change about 50 packages where I...

Maybe this helps:

In the log File of TPT I can see that the session character set on Teradata is UTF8. Seems to work fine in this place.

As far as I...

Hi Mike,

I tried this already (using "Show Advanced Editor" of Source --> "Input and Output Properties" --> "Output"), but after closing the dialog box and saving the package the re-open...

Hi,

using the TPT 13.10 or 14.10 it's working smoothly...

Maybe this helps someone else.

Best regards

Helmut

Thanks Tommy for this great procedure.

But there's a problem if you want to merge a table with more than 2 columns in the PK.

If you change

SELECT @pk_2 = 'AND...

Great job! It's very useful!

Helmut

Thanks James, You did a great job! It's working perfect!

Best regards

Helmut

Hi Ben,

maybe you're question is already answered (I think so). But you can find the result of the Transaction Log Shipping Report in the Tables:

msdb..log_shipping_monitor_primary (for the primary server) and...

Hi MANU,

yes my login that I'm using is a sysadmin.

But in the meantime I think I solved the problem:

I was using a domain account (domain-admin and sysadmin) on primary server...

Hi Michael,

I already tried it without fast load option but there's another error:

Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E37 Description: "Invalid object name ..."

But the...

Ok,

I tried an SQL Server Destination and the following error occurred:

Unable to prepare the SSIS bulk insert for data insertion.

With this error I came to an article written by Jamie...

Hi pduplessis,

good question!! That is definitely working.

But I just wanted to try out if it would work with linked server.

Do you see any reasons why it's not working....

Yeah, the performance increased. Sorry, I didn't measure it but there was definitely an increase.

Helmut

Sorry, I cannot reproduce it, 'cause the indexes of the big table are rebuilt now. But I think I can remember that there was a Index Scan.

Regards

Helmut

Now I got it!

I re-arranged the index columns to col2, col3, logtime. It also fits to the other statement, because col2, col3 and logtime are always used together.

Thanks to...