:::: MENU ::::

Posts Categorized / SQL Server Integration Services (SSIS)

  • Aug 21 / 2013
  • 0
dbDigger, DDL, DDL Triggers, SQL Server Error messages, SQL Server Integration Services (SSIS), Triggers

Error generated in SSIS task

While importing few tables from server instance to another i got following error message.

http://4.bp.blogspot.com/-SQO5uAIPeh8/UhTljUKxEWI/AAAAAAAADR4/Xm_GZfJcKfQ/s1600/Problem+with+the+query+Result+Set+property+not+set+correctly,+parameters+not+set+correctly+or+connection+not+established+correctly

The user does not have permission to perform this action. Possible failure reasons: Problem with the query. “Result Set” property not set correctly, parameters not set correctly or connection not established correctly.

Error message was not looking fit for my scenario. In the mean while i got another report about errors being generated while creating tables on same server. The error message was pointing to failure of a DDL trigger meant for logging purpose. The trigger was being invoked on table creation and got failed due to permission issues while inserting logs in trigger log table. So i disabled the trigger and executed the task again. This time task was completed successfully.

So if you fall in above mentioned scenario then along with checking the reasons provided in error message also look for DDL trigger context.

Consult us to explore the Databases. Contact us