locked
Copy Activity Teradata to Azure Blob throws error RRS feed

  • Question

  • The sink blob slices fail with error:

    Copy activity encountered an unknown server error: Code: 0 ; Message: 'Type=System.NotSupportedException,Message=The given data source reference cannot test the connection. FailureReason: InvalidDataSourceReference.,Source=Microsoft.Data.Mashup,'.

    I can connect successfully using Excel and ODBC driver to the Teradata DW from the machine where the DMG is installed.

    Is there a way to troubleshoot this issue?

    Wednesday, August 12, 2015 8:26 AM

All replies

  • Hi Asif,

    Sorry the late response. And I replied your question in another thread. Paste it here.

    Could you help to check the value of the 'database' property in the Teradata LinkedService? Please make sure the it is set to null, otherwise you may encounter the TestConnection error.

    For Teradata, there should be no the database concept, but there is a UI issue now and if you specify it, which would trigger issues. Engineer team is working on the fix.

    Thanks,

    Joyce

    Wednesday, August 19, 2015 3:07 AM