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";<[email protected]>;
Date:  Fri, Jan 19, 2018 08:03 PM
To:  "Rakesh Kumar"<[email protected]>;"Der Fluch"<[email protected]>;"[email protected]"<[email protected]>;"[email protected]"<[email protected]>;

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 <[email protected]>
 Sent: Friday, January 19, 2018 6:58:55 AM
 To: [email protected]; [email protected]; [email protected]
 Subject: Re: Can not execute DDL in SSIS.  
 
 
  Isn't SSIS SQL Server based tool.   What has it got to do with PG?