all groups > sql server dts > april 2007 >
You're in the

sql server dts

group:

Error Message in SSIS


Error Message in SSIS Dave Linker
4/21/2007 7:29:12 PM
sql server dts:
Greetings and Salutations All,

I am new to SSIS and am building a package that will take a
denormailized flat file and move its pieces to a SQL Server 2005 DB.

I have used the flat source in numerous earlier data flow (df) steps
with no trouble, column 11 is checked off for all the previous uses of
the flat file source.

The text of the messages is below:

Error at AddInfoDataDF [DTS.Pipeline]: input column "Column 11" (3772)
has lineage ID 3826 that was not previously used in the Data Flow task.


Error at AddInfoDataDF [DTS.Pipeline]: "component "FinDataInfoAdd"
(3758)" failed validation and returned validation status
"VS_NEEDSNEWMETADATA".


Error at AddInfoDataDF [DTS.Pipeline]: One or more component failed
validation.


Error at AddInfoDataDF: There were errors during task validation.

can anyone assist me with this troubke? I have deleted the DF and
re-created numerous times, removed and re-created the ole destintation,
flat source and every other component in the data flow.

Please, pardon any and all typing errors as i am a two finger kinda
guy...

Many Thanks in advance,
DGL



Re: Error Message in SSIS Allan Mitchell
4/22/2007 12:00:00 AM
Hello Dave,


What is this component "FinDataInfoAdd"

This error suggests that the component has seen the column before but that
when it did it had a different lineageID. LineageID is the way that SSIS
keeps track of the columns inside the pipeline.

If you open the pipeline you should from where the error is originating.
If you double click on that component you should get the opportunity to
fix things up.



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

AddThis Social Bookmark Button