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@xxxxxxxx>;
Date: Fri, Jan 19, 2018 08:03 PM
To: "Rakesh Kumar"<rakeshkumar464@xxxxxxx>;"Der Fluch"<446509381@xxxxxx>;"pgsql-odbc@xxxxxxxxxxxxxx"<pgsql-odbc@xxxxxxxxxxxxxx>;"pgsql-admin@xxxxxxxxxxxxxxxxxxxx"<pgsql-admin@xxxxxxxxxxxxxxxxxxxx>;
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@xxxxxxx>
Sent: Friday, January 19, 2018 6:58:55 AM
To: 446509381@xxxxxx; pgsql-odbc@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Can not execute DDL in SSIS.
Sent: Friday, January 19, 2018 6:58:55 AM
To: 446509381@xxxxxx; pgsql-odbc@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Can not execute DDL in SSIS.
Isn't SSIS SQL Server based tool. What has it got to do with PG?