Hi,

I get "product level is insufficient..." error when I run my SSIS package from workstation (from the Mgmt studio), though i could run the package from the server and the BIDS (client node) as well.
Any installation is missing in the workstation?

Your suggestion is highly appreciated.
Thanks in advance.



Thanks,
Chandra

__________________
Thanks,
Chandra

What is installed on your workstation? You need a certain level of SQL Server (not just management studio) installed to run SSIS packages.

-Peter
compiledthoughts.com

Mgmt Studio, BIDS, Performance Tools, analysis service, Configuration tools. These are the components i can see it in the SQL Server 2005 Menu.

Thanks,
Chandra

Also, when i run the SQL Jobs 2000 scripts in Mgmt Studio for migration of jobs, i could not find the jobs in my Mgmt Studio->Jobs
no steps and nothing is listed. But the same is there when i logon to the Server. Do i need to install any patch/service pack in my workstation. Please advise.

Thanks,
Chandra

I'm not really sure. I think you may have passed my level of expertise in this subject.

-Peter
compiledthoughts.com

After eyeing various blogs, i came to know that the SSIS package cannot be executed from the workstation, but its possible to execute the package from BIDS. If you need to execute from the workstation Mgmt Studio we need Integration services running on our workstation and to be noted is Client components doesnt come with Integration services. So better to execute the package from server or as a job or go with full installation of SQL Server in the workstation, probably that could be a license issue. Please correct me i'm wrong.

Thanks,
Chandra