Re: Can not execute DDL in SSIS.

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(dot)d(dot)byrd(at)live(dot)com>;
Date: Fri, Jan 19, 2018 08:03 PM
To: "Rakesh Kumar"<rakeshkumar464(at)aol(dot)com>;"Der Fluch"<446509381(at)qq(dot)com>;"pgsql-odbc(at)postgresql(dot)org"<pgsql-odbc(at)postgresql(dot)org>;"pgsql-admin(at)lists(dot)postgresql(dot)org"<pgsql-admin(at)lists(dot)postgresql(dot)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(at)aol(dot)com>
Sent: Friday, January 19, 2018 6:58:55 AM
To: 446509381(at)qq(dot)com; pgsql-odbc(at)postgresql(dot)org; pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Can not execute DDL in SSIS.


Isn't SSIS SQL Server based tool. What has it got to do with PG?