?
Solved

SSIS 2005 - Execute Package Task error

Posted on 2012-08-17
5
Medium Priority
?
731 Views
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.

Thanks
0
Comment
Question by:Amour22015
  • 3
5 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 38308337
Hi,

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.

HTH
  David
0
 

Author Comment

by:Amour22015
ID: 38308450
Hi,

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?).

thanks
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 38311444
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.
0
 

Accepted Solution

by:
Amour22015 earned 0 total points
ID: 38311772
Hi,

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:
"ExecuteOutOfProcess"
I had this set to True

I changed it to False

Seems to be working

Thanks
0
 

Author Closing Comment

by:Amour22015
ID: 38332109
Great
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
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 how to count occurrences of each item in an array.
Suggested Courses

850 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