SSIS 2005 - Execute Package Task error

Posted on 2012-08-17
Last Modified: 2013-11-18
Hi and thanks for helping

If I run this package it works fine.
But if I run this package using "Execute Package Task"  I get errors

What does this mean?
SSIS Error Code DTS_E_PRODUCTLEVELTOLOW.  The product level is insufficient for component "Data Conversion 1" (101).

Now I look on the internet and it mentions upgrade of the SSIS 2005?

This is Microsoft Virual Studios 2005 ver 8

But if that is the case then why does it work when I run the same package not using the "Execute Package Task"?

Maybe I am not using the "Execute Package Task" correctly for this package that it is calling?

I am using the File Connection Editor (creating a connection) "existing File".
and in the "Execute Package Task" I am using:
Location: File System
Connection: Name of the package I am trying to execute.

Question by:Amour22015
    LVL 35

    Expert Comment

    by:David Todd

    SQL tends to be one version behind Visual Studio. That is, use the BIDS that comes with your version of SQL.

    What I suspect is that the SSIS version that your Visual Studio is targetting is SQL 2008 or better.


    Author Comment


    This is in the same project?

    That is:

    The package that works ok by itself is in the same project name as the one calling this package.

    There is no different verisons.

    The reason why I am using "Execute Package Task" is to call another package that is too large for the one calling.

    I am using Visual Studio 2005, BIDS 2005, SSIS 2005 (aren't they the same?).

    LVL 21

    Expert Comment

    So when you run the package in BIDS it works fine, or when you schedule it on the server?

    make sure your server has SSIS installed and the service is running also.

    Accepted Solution


    The server has SSIS installed?, SSIS 2005, I am new to all this and really don't know the difference between BIDS and SSIS.  Aren't they the same?

    I think I found the problem:

    In the "Execute Package Task"

    there is an option:
    I had this set to True

    I changed it to False

    Seems to be working


    Author Closing Comment


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    MS SQL 2005 Srink database in chunks 4 33
    Problem to file 3 29
    SQL Server 2012 express 24 21
    Grunt No Clean Targets 6 13
    What is Node.js? Node.js is a server side scripting language much like PHP or ASP but is used to implement the complete package of HTTP webserver and application framework. The difference is that Node.js’s execution engine is asynchronous and event…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
    The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now