DTS deployment issues

Hello!

I'm trying to deploy an application that runs DTS packages from the local machine.

I've read some articles that it would be enough to install the SQL Client Tools on the local machine to make the DTS work . I did this, the package executes a few steps (it shows message boxes and writes data into the database), then (before executing some validation tasks on the data) it throws an exception 'Execution was canceled by user'. I've set the pbCancel flag and the package runs fine on some computers, but on an empty system that only contains my application and the Sql Client Tools I get this exception.

Do I have to install anything else or do I have to make some changes to DTS package to make it work?

Thank you in advance!

this is the wrong forum; Unless your are using SSIS (SQL SERVER 2005).|||sorry, my mistake

DTExecUI - Package Execution Utility Error

Hi,

when i deploy my package using the DTExecUI thru the Package Execution Utility.when we execute the package . we are getting the following error.

The Product Levelis insufficient for component "Flat File Source(1)"

the package design is

FlatFileSource -> OlEDBDestination

what could be the solution for this?

Thanks

Jegan

You need to install SSIS on this machine.
Most likely you've installed Workstation Components, but to run packages outside of designer environment you need to install SSIS (separate checkbox on one of first setup pages).|||Thanks Michael

DTExecUI - Package Execution Utility Error

Hi,

when i deploy my package using the DTExecUI thru the Package Execution Utility.when we execute the package . we are getting the following error.

The Product Levelis insufficient for component "Flat File Source(1)"

the package design is

FlatFileSource -> OlEDBDestination

what could be the solution for this?

Thanks

Jegan

You need to install SSIS on this machine.
Most likely you've installed Workstation Components, but to run packages outside of designer environment you need to install SSIS (separate checkbox on one of first setup pages).|||Thanks Michael