- Posts: 2
- Thank you received: 0
Error executing Package
8 years 10 months ago - 8 years 10 months ago #11726
by jgreenhaw
Error executing Package was created 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
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.
8 years 10 months ago #11727
by admin
Mike
ETL Architect
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
Please read the forum rules and post the rest.
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
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
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
Please Log in or Create an account to join the conversation.
8 years 10 months ago #11730
by admin
Mike
ETL Architect
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
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 10 months ago #11773
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Error executing Package
How is it going?
We are keen to resolve this issue
We are keen to resolve this issue
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.