Post reply

Insert data using data flow task from one server to another server

  • December 28, 2020 at 8:53 pm

    #3824843

    Hi I need help on the following.

    I have a data flow task which reads data from sqlserver1(source)  and inserts data into sqlserver2(destination).Once it is done then I have to encrypt the connection_string column.

    I am facing issues since I am using open symmetric key and close symmetric key the connection is being closed  in DF task and data cannot be transferred.Both source and destination are on different server  and table structure is same. I am using ADO.net source and destination.

    error:[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: Column 'connection_string' does not allow DBNull.Value.

    Please suggest me alternative solution for this.Let me know if you have any questions.

  • December 29, 2020 at 12:03 pm

    #3825075

    Where in the process is the value being set to NULL? The source, somewhere in the data flow, or at the destination? (I suggest you use a Data Viewer if you are unsure.)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply