Post reply

SQL Server Import\Export wizard error

  • December 10, 2008 at 6:43 am

    #129214

    Hi,

    I am having a problem executing an SSIS import package from SS Management Studio (Standard version - client application) using the Import\Export wizard. I'm attempting to import data from Excel into a table and can even preview the data in the wizard, however when I try to execute the SSIS package, I get the following error - "Error 0xc00470fe: Data Flow Task: The product level is insufficient for component...".

    From my research around this problem it seems like it is a SQL Server bug and to fix this problem, I need to install the SSIS package on the workstation PC. If this is true, where could I install this package from? Any help for importing data with the SSIS package from the SQL Server workstation (Standard version) would be appreciated or a pointer in the right direction.

    Note: the server has the SSIS service installed, the workstation does not have the SSIS service installed.

    Thanks in advance for your help.

    -Kauser

  • December 10, 2008 at 10:11 am

    #910521

    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

  • December 10, 2008 at 12:10 pm

    #910593

    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

  • December 10, 2008 at 12:36 pm

    #910611

    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

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

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