Error executing Package

More
8 years 10 months ago - 8 years 10 months ago #11726 by jgreenhaw
I created several Transformations that work well. No errors.
But when I add them into a Package and execute i get an error.
The error is: "0-19 is not a valid integer value.".
0-19 is the number for rows we are skipping in the xls file.
How can I resolve this?
Thanks,

Jim
Last edit: 8 years 10 months ago by jgreenhaw.

Please Log in or Create an account to join the conversation.

More
8 years 10 months ago #11727 by admin
Replied by admin on topic Error executing Package
It is hard to tell what is wrong with that without additional information.

Please read the forum rules and post the rest.

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 10 months ago #11729 by jgreenhaw
Replied by jgreenhaw on topic Error executing Package
Using: Advanced ETL Processor Ent
Version = 5.7.9.38
OS = Win 2008R2
Repository = SQL Server 2008R2
Problem = Error when running transformations in Package. Error is "0-xx is not a valid integer value."
I've been able to recreate it by defining an excel file that skips rows. In the "Lines to Skip" section of the Excel Files properties page. When I execute in the transformation screen no error. But in the Package screen I get an error.

I attached the files I think are needed. I wasn't sure about the mapping attachment. I hope I got that saved correctly.

Thanks
Attachments:

Please Log in or Create an account to join the conversation.

More
8 years 10 months ago #11730 by admin
Replied by admin on topic Error executing Package
Interesting error
Can you also provide table creation script.
And source file.
You may need to zip it first.

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 10 months ago #11773 by Peter.Jonson
How is it going?
We are keen to resolve this issue

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.