Hello, I'm trying out the provider will SSIS and have run into a few problems that I consider fundamental and wondered who else uses dotConnect for Postgres in SSIS and what they use it for.
The issues are as follows (the last two have work arounds, but the first doesn't (and is most important):
1: In a Data Flow Task, you can't specify parameters for an ADO.Net Data Source with data access mode set to SQL Command - there is no way to provide the mapping between any SSIS variables and SQL parameter.. there should be a button that allows you to do this, but it doesn't exist.
2: In an "Execute SQL Task", you can't used @ or : named parameters, only ? and $n work.
3: In an "Execute SQL Task", you can't refer to the name of the column in a single row result set, you have to refer to it by index
SSIS Issues
1 and 3: Have you got any other ADO.NET provider to work properly with these features? I have tried System.Data.SqlClient and obtained the same behaviour. Most probably, the 1st and 3d issues are common limitations for all ADO.NET providers. As I understand, you are using OLE DB provider: http://ssis.wik.is/Understanding_Connec ... T_vs_OLEDB.
2: We will investigate this problem and notify you about the results as soon as possible.
2: We will investigate this problem and notify you about the results as soon as possible.