Attunity works from BIDS (Standad Edition)?

Question

Attunity works from BIDS (Standad Edition)?

naresh.elugala

SSC Veteran

Points: 277
More actions
October 4, 2011 at 9:24 am

#244773

Hi,
I have used this Attunity client in Staging environment, which has Enterprise evaluation version.
When I moved to Production which has Standard edition, the packages run when executed from BIDS. But doesnot run when executed in Job Agent or when executed from outside BIDS (like right click on the Package in a folder and say Open and then execute).
My Question is why this is working from BIDS even though I am on standard edition.
Regards,
N

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

prvmine SSCertifiable Points: 7007 More actions · Answer 1

There can be several things contributing to your package not executing in you production environment from the Job Agent the two most likely are

- permissions- the job agent does not correct level of permissions

- your package contains an Enterprise component(s) not supported in the Standard version

naresh.elugala SSC Veteran Points: 277 More actions · Answer 2

Thanks for your reply.

I knew that it is enterprise component and not supported in standard Edition but my question is "why this is working from BIDS even though I am on standard edition."

prvmine SSCertifiable Points: 7007 More actions · Answer 3

So if you have eliminated the differences between Enterprise and Standard then check the differences between permissions of your account in BIDS and SQL Server Agent.

Have you grant db_ssisOperator or db_ssisAdmin for the package in the MSDB?

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

My experience tends to indicate that BIDS will run the component even if it is a higher edition. Not sure I can prove that.

But will fail when you try to run it outside BIDS because of the edition mismatch.

CEWII

prvmine SSCertifiable Points: 7007 More actions · Answer 5

prvmine

SSCertifiable

Points: 7007

October 4, 2011 at 12:47 pm

#1390306

Agreed, that is my experience as well

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

I think the idea is that the tools will let you develop for any edition but you can't actually run them on the server unless the features are supported by that version.

CEWII

naresh.elugala SSC Veteran Points: 277 More actions · Answer 7

Attunity does support Enterprize as well as developer Edition. Id it becuase of this it is executing in BIDS?

prvmine SSCertifiable Points: 7007 More actions · Answer 8

When you say "But doesnot run when executed in Job Agent or when executed from outside BIDS"

what is the error message?

It would also be helpful to know

Have you deployed other SSIS packages to your production server?

What version of BIDS are you developing in and the SQL Serversion version

Is Attunity only in your Staging environment

naresh.elugala SSC Veteran Points: 277 More actions · Answer 9

When you say "But doesnot run when executed in Job Agent or when executed from outside BIDS"

what is the error message?

SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The component "Tgt_Test" (19) cannot run on installed Standard Edition (64-bit) of Integration Services. It requires Enterprise Edition (64-bit) or higher.

Have you deployed other SSIS packages to your production server?

I did.

What version of BIDS are you developing in and the SQL Serversion version

2008 R2

Is Attunity only in your Staging environment

Its in Prod as well. I could download it on standard version also.