DTS_E_INDUCEDTRANSFORMFAILUREONERROR.

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

SQL Server 2005 Forums

SSIS and Import/Export (2005)

DTS_E_INDUCEDTRANSFORMFAILUREONERROR.

Author

Topic

sgandhi
Posting Yak Master

115 Posts

Posted - 2009-02-18 : 12:19:23

Hi, i have data like this in a column called VAT.
Im am loading this data from an XML file into a sql server table using ssis.

But im getting this error.
[XML Source [10759]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "XML Source" (10759)" failed because error code 0x80131537 occurred, and the error row disposition on "output column "Vat" (38422)" specifies failure on error.
An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

The column is a decimal in the output of the xml source and a float on the sql server table. But the file is happening at the xml source level.

I have tried changing the source to double precision float, are dt_wstr. I need help

VAT
205.105
50.673
0
0
0

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-18 : 13:30:51

did you try casting it to required type (DT_NUMERIC) using a derived column or data conversion transformation?

http://sqlblog.com/blogs/andy_leonard/archive/2009/02/04/ssis-expression-language-and-the-derived-column-transformation.aspx

http://msdn.microsoft.com/en-us/library/ms140321.aspx

sgandhi
Posting Yak Master

115 Posts

Posted - 2009-02-18 : 13:47:46

that didnt work either. It keeps failing on the xml source

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources