SQL Server Import\Export wizard error

Question

SQL Server Import\Export wizard error

Viewing 3 posts - 1 through 4 (of 4 total)

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

This explains the error you're getting and what to do about it: http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

You have two choices:

1. install Integration Services on the workstation and execute the package from there. You have to install from the disk again making sure you check Integration Services as a component to install

2. Copy the package to the server and run it there by connecting to Integration Services in SSMS. You can save a package to the server (SQL Server or file system) from BIDS. See package deployment in BOL.

In my opinion, the second option is the best and easiest thing to do.

I'm a little confused by your description of trying to execute the package from the Import/Export Wizard. As far as I know, an existing package can't be executed from the Wizard although a package can be created in the Wizard using the criteria specified in the previous screens.

Greg

kshahpurwala Grasshopper Points: 24 More actions · Answer 2

Thanks Greg! - I'll try the recommendations.

Reference your confusion about the execution of the package. What I meant was that the import\export wizard walkthrough, has a screen that provides the option to save and execute package. This screen provides a check box option to execute package immediately, which is what I was attempting to do. Hope this clarifies what I meant. Appreciate your help.

Thanks,

Kauser

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

Oh, I see. I had the impression you were trying to execute a previously saved package.

I should add that another common way of executing a package on a server is to schedule it in a SQL Agent job.

Greg