The product level is insufficient for component "Data Conversion 1" (117)

20 New Member

Hello,

edit: added some more info

I am trying to set up a job to run a SSIS package in SQL 2005, the SQL 2005 is installed on a Windows server 2003 machine.

start Edit
I have the Management studio (I am working from) installed on windows XP (fully up today with the SPs). I have the installed on this machine the integrated Services, I do not know if they have been installed on the Windows 2003 machine that has the DB.
end Edit

The job is failing with the following error message:

Expand|Select|Wrap|Line Numbers

 Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW.  The product level is insufficient for component "Data Conversion 1" (117).  ...  The package execution fa...  The step failed.
 

Some background:

The Package
The Package it's self has the job to Pull all the data from a table between specified dates, in this case, last weeks data. it then exports the results to an Access Database.

when I create the package, if I do the "run it now" option it works, it runs with out error and successfully exports the data.

I then created the same package with all the same options except this time I saved it to the file system.

The Job

My next step is to set up the job, I set this up to pick the package and run it, once a week at a specified time.

I save the new job and then manual ask it to run(for a test)

when the job runs it errors with the above mentioned error message.

for all of this I am using the System Admin user to create and deploy this job/package.

any suggestions would be greatly appreciated as remote desktoping to work on the weekends to manually create and run the package is not how I want to spend my weekends.

Thanks

Dec 14 '07 #1

Subscribe Reply

6927

Javilen

New Member

For the interested people.

We installed the integrated Services onto the server and then remote desk topped into the machine and logged in as the DB owner.

We created the package from scratch and the job under this login.

When we ran the job it worked without error.

Thanks

Dec 14 '07 #2

Similar topics

1227

What is the difference between a "component" and a "class"?

by: Jason | last post by:

In reading various technical documents, it often seems as though these two terms are used interchangably. However, the Visual Studio.NET IDE does have an Add New for class and component which, in this case, seems to be more UI related.

.NET Framework

5355

How to make a "Out of Process Component" (ActiveX Exe Serve) in Do

by: Berata | last post by:

Hello all, in VB6 we were able to create ActiveX-DLL's (In Process Components) and ActiveX-Exe's (Out of Process Components). We habe build up an application that exists of an main module (Standard Exe) that calls and controls other modules (ActiveX-Exe). We decided for ActiveX-Exe because they run in different processes. That means if one module shuts down, the others are still alive. Second reasons

.NET Framework

1611

"Access Denied" using Server "Serviced Component"

by: Oliver | last post by:

hi - I have a written a "Serviced Component" which works fine when declared as: but I am seeing an 'Access Denied' exception when I declare it as: this is probably something to do with Roles etc, but I'm clueless ;)

C# / C Sharp

1701

R e: "Access Denied" using Server "Serviced Component"

by: Oliver | last post by:

> I am seeing an 'Access Denied' exception when using a "Server" "Serviced Component" >> ..are...registered in the GAC ? yes. >> ..are...the parameters serializable? um - parameters? - the method parameters? - yes think so - there's only one and it's a 'string' here's an example class that illustrates the problem:

C# / C Sharp

2626

2 Questions on Reading Binary File; "Conversion buffer overflow"

by: poifull | last post by:

Hi All, What is the proper way to read a binary file into a byte? I am using BinaryReader to read from a Stream and call the ReadByte method of the BinaryReader object. The method I'm using leads to the second question. I got the "Conversion buffer overflow" error when I run the following code: Stream s = openFileDialog1.OpenFile();

C# / C Sharp

1314

VS.NET 2003 Project "Conversion"

by: George Durzi | last post by:

Hey folks, I just installed VS .NET 2003 on top of Windows 2003 Server. I was opening a Web Project from source control, and got a warning that the project would have to be "converted", and that I could no longer edit it in older versions of Visual Studio. What does this conversion entail. It seems like a 1 way path.

ASP.NET

2033

low level data types

by: dementrio | last post by:

How can I handle low-level data types in Python? What I want to do is writing an interface to a C daemon which waits for stuff like unsigned ints on a socket. For example, I need to craft and decode data structures that look like this: 32-bit unsigned int MSG_LENGTH 32-bit unsigned int MSG_CODE 64-bit signed int DATA 32-bit length + utf-8 characters STRING_DATA etc.

Python

1216

WSE3.0 doesn't work with trust level="Medium" need help!

by: Stu | last post by:

I x-posted this in the enhancements group as well, looking for some help: Need help with a CAS issue with WSE3. Enable an asp.net2 webapp to use WSE3. Create a new webservice in the app via Add New Item WebService Alter code for webservice so the service inherits from SoapService, instead of the defaults, like so: (this forces your service to use

.NET Framework

4081

error using GetObject - "cannot create ActiveX component"

by: ironmanlarry | last post by:

Hi, I'm trying to do a mail merge from Excel to Word (programatically) and I'm having some trouble creating the Word Document Object. This line of code wordDoc = GetObject("sheet.doc") keeps returning the error "cannot create ActiveX component" and then the program crashes. Any help is much appreciated. Thank you. Larry

Visual Basic 4 / 5 / 6

8888

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8752

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9401

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9111

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6702

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4782

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3221

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2634

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2157

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General