December 28, 2020 at 8:53 pm
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
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.)
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply