Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Error

Author

Topic

Joshrinn
Posting Yak Master

118 Posts

Posted - 2012-04-26 : 09:39:54

[SSIS.Pipeline] error: "component" cache transform1"(35)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-26 : 10:48:42

The above message just suggests there's some problem with metadata but it can be due to variety of reasons like change of source table structure, Errors in parsing source query etc

Is there some other error messages thats displayed with this?
Can you give a high level idea on what exactly you're doing inside this package with tasks used?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Joshrinn
Posting Yak Master

118 Posts

Posted - 2012-04-26 : 11:16:21

[SSIS.Pipeline] Error: "component "Cache Transform 1" (35)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

[SSIS.Pipeline] Error: One or more component failed validation.

Error: There were errors during task validation.

I have used excel source, data conversion component and cache transform component.

the above errors are on data conversion and cache transform

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-26 : 12:20:38

can you check if your excel source file has changed or is missing header information?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Joshrinn
Posting Yak Master

118 Posts

Posted - 2012-04-26 : 13:06:33

I could move forward but got this erro now:

[Execute SQL Task] Error: Executing the query "BEGIN TRANS Trans_MR"
failed with the following error: "Incorrect syntax near 'TRANS'.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.

Joshrinn
Posting Yak Master

118 Posts

Posted - 2012-04-26 : 13:14:36

I took care of that one thanks. But the whole package has been completed but there was a warning message like this:

[SCR_RecsUpdated [1]] Error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException:
The value is too large to fit in the column data area of the buffer.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[]
outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)

Is this a problem?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-26 : 15:22:36

i think this is thrown by cache transformation. Did you change some lengths of fields lately?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Joshrinn
Posting Yak Master

118 Posts

Posted - 2012-04-26 : 15:32:12

No I did not. But does this go on my memory buffer or C:/> because I see the system just allocated me 174 MB.

Joshrinn
Posting Yak Master

118 Posts

Posted - 2012-04-26 : 16:04:07

All that it gives me is the script error which gives me script runtime error and a message displaying value is too large to fit in the column data area of the buffer. The error is inside the DFT. Here is the script code just in case if its helpful

Microsoft SQL Server Integration Services Script Component
' Write scripts using Microsoft Visual Basic 2008.
' ScriptMain is the entry point class of the script.

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

<Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute> _
<CLSCompliant(False)> _
Public Class ScriptMain
Inherits UserComponent

Public Overrides Sub PreExecute()
MyBase.PreExecute()
'
' Add your code here for preprocessing or remove if not needed
'
End Sub

Public Overrides Sub PostExecute()
MyBase.PostExecute()
'
' Add your code here for postprocessing or remove if not needed
' You can set read/write variables here, for example:
' Me.Variables.MyIntVar = 100
'
End Sub

Public Overrides Sub CreateNewOutputRows()
With RecsUpdatedBuffer
.AddRow()
.JobStartTime = Me.Variables.StartTime
.JobDurationSecs = DateDiff(DateInterval.Second, Me.Variables.StartTime, Now())
.StatusMessage = Me.Variables.varCntRecsUpdated & " no:of recs were updated for the month end " & Me.Variables.varMaxProcessDate
End With
' Add rows by calling the AddRow method on the member variable named "<Output Name>Buffer".
' For example, call MyOutputBuffer.AddRow() if your output was named "MyOutput".
'
End Sub

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources