Re: Can not execute DDL in SSIS. - Mailing list pgsql-odbc
Thanks all for the reply.
I think I have found the issue.
I installed the dsn from a program which set the permission to readonly. So even I changed the user to admin, it still performed read only operation.
While in pgadmin, it does not use the dsn, so there is no permission issue.
Thanks any way.
------------------ Original ------------------
From: "Jonathan Byrd";<jonathan.d.byrd@live.com>;
Date: Fri, Jan 19, 2018 08:03 PM
To: "Rakesh Kumar"<rakeshkumar464@aol.com>;"Der Fluch"<446509381@qq.com>;"pgsql-odbc@postgresql.org"<pgsql-odbc@postgresql.org>;"pgsql-admin@lists.postgresql.org"<pgsql-admin@lists.postgresql.org>;
Subject: Re: Can not execute DDL in SSIS.
SSIS can connect to anything and presumably send the DDL statements to be executed on the target DB
Sent with Outlook for iOS
From: Rakesh Kumar <rakeshkumar464@aol.com>
Sent: Friday, January 19, 2018 6:58:55 AM
To: 446509381@qq.com; pgsql-odbc@postgresql.org; pgsql-admin@lists.postgresql.org
Subject: Re: Can not execute DDL in SSIS.
Sent: Friday, January 19, 2018 6:58:55 AM
To: 446509381@qq.com; pgsql-odbc@postgresql.org; pgsql-admin@lists.postgresql.org
Subject: Re: Can not execute DDL in SSIS.
Isn't SSIS SQL Server based tool. What has it got to do with PG?
Attachment
pgsql-odbc by date: