I am getting SSIS ETL error while running Copy Command to load data into Vertica
I build one ETL package which is taking care of below steps.
1. It will get the data from Sql server Tables and generate .CSV file in shared folder.
2. After completetion of above step then immedaitlly Execute SQL task will initiate and COPY Command will run and loading the data from CSV file to VERTICA Table.
Now in the above two steps first step got succeded but second step was failing due to below error.
" [HY000] Unexpected protocol message: DataRow". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
I am unable to fix this. Could any one please help on this.
Thanks in advance.