Copying a project - error occurs in transformation

More
12 years 11 months ago #1086 by Frank
I have a new project which is similar to a previous project. to save time, what I did was rename the old project to the name of the new project, backup the respository, rename the old project to the previous name, and then restore the old project (with the new name) back into the repository. This should create a copy of the project with the new name, and, it looks to work.

However.....

This seems to break the transformation of the original project if you open the transformation of the old or new project. Even if you re- restore the old project from the backup, it still breaks while running the package.

It also seems that since I have done this, even after restoring the entire old project, if I open the transformation of the old project, it stops working during the package.

Here is a copy of the log file:

Information 10/15/2010 6:26:49 AM Preparing to execute: Use this - All Processes Continuous
Information 10/15/2010 6:26:49 AM Package Started
Information 10/15/2010 6:26:49 AM Executing Transformation: Process Guests
Information 10/15/2010 6:26:49 AM Source File(s): D:\AutoProcess\RegentBalHarbour\Guests\
Information 10/15/2010 6:26:49 AM Processed: Records
Information 10/15/2010 6:26:49 AM Errors:
Information 10/15/2010 6:26:49 AM Rejected:
Information 10/15/2010 6:26:49 AM Records per second:
Information 10/15/2010 6:26:49 AM Execution of Transformation has failed
Information 10/15/2010 6:26:49 AM Sending Email: Guest Processing Failed
Information 10/15/2010 6:26:49 AM To:

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

More
12 years 11 months ago #1087 by admin
You have posted the package log

Have a look at the data transformation log

It will tell you what is he problem

Most like you need to change the conenction

Mike

Mike
ETL Architect

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

More
12 years 11 months ago #1088 by Frank
Here is the issue from the transformation log, however, I haven't touched the transformation for that project and don't understand how it could change

Error 10/14/2010 6:16:13 AM Transformer: Execution Aborted: Table's Structure Has Changed (The Number of fields is different)

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

More
12 years 11 months ago #1089 by admin
Open transformation and check data writer properties
Than open last transformation before data writer and click OK

Peter

Mike
ETL Architect

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