Will run in SSIS Designer but not from DTExec

Hi all,
I have a package that runs fine in SSIS Designer but not from DTExec. I get the following 2 error messages:

The task "Reset variables" cannot run on this edition of Integration Services. It requires a higher level edition.
The task "Prepare variables" cannot run on this edition of Integration Services. It requires a higher level edition.

Those 2 tasks are both script tasks.

The version number on both installations is the same (i.e. 9.00.1314.00).

In DTexec.exe.config, requiredRuntime version=v2.0.50727 on both machines. I'm not sure how to actually check what the version number of the runtime is.

Any ideas anyone

-Jamie

Answer this question

Will run in SSIS Designer but not from DTExec

RakeshShah

Runying Mao wrote:

It seems you don't have SSIS installed. Please re-run setup.

Please see this thread - http://forums.microsoft.com/msdn/ShowPost.aspx PostID=110020

Product level is not checked in designer. That explains why you don't see the above errors when running packages in designer.

DOH!!!

In my defence I didn't prep the machine and I was told SSIS was on there. Honest guv!!! Smile

Smile

Job 1 tomorrow morning - install the goddamn software Smile

Smile

eperales

It seems you don't have SSIS installed. Please re-run setup.

Please see this thread - http://forums.microsoft.com/msdn/ShowPost.aspx PostID=110020

Product level is not checked in designer. That explains why you don't see the above errors when running packages in designer.
Will run in SSIS Designer but not from DTExec

Answer this question