Error: The attempt to send a row to SQL Server failed with error code 0x80004005.

quote:

---

This maybe?
http://www.google.com/search?hl=en&safe=off&rls=com.microsoft%3Aen-US&q=%2B%220x80004005%22+%2B%22SSIS%22

Otherwise code 0x80004005 is often used for permission errors.

---

quote:

---

Run SQL Profiler to determine what is occurring on the server-side.

---

quote:

---

No it isn't running while you run the package. You have to start it up. Do you have sysadmin privileges on the SQL Server? If so, run SQL Profiler and have it trace for exceptions and errors. Then cause the error so that the trace captures it. View the trace information to determine what is exactly going on.

If you don't have any experience with SQL Profiler, I'd suggest you contact the DBA of this system to help you out with this.

---

Error: 9803, Severity: 16, State: 1
Invalid data for type "numeric".

SELECT *
FROM [dbo].[MyTableName]
WHERE (IsNumeric([MyFieldName]) = 0) AND NOT ([MyFieldName] = '')

DECLARE @TableName NVARCHAR(150), @FieldName NVARCHAR(150);

SELECT @TableName = 'table1';
--SELECT @FieldName = 'field1';
--SELECT @FieldName = 'field2';
SELECT @FieldName = 'field3';

EXEC('SELECT *
FROM [dbo].[' + @TableName + '] t 
WHERE t.[' + @FieldName + '] LIKE ''%[^0-9.]%''');

CREATE TABLE [dbo].[hotel_list_TEMP](
	[vendor_id] [int] NOT NULL,
	[brand_code] [nvarchar](50) NULL,
	[hotel_name] [nvarchar](150) NOT NULL,
	[address_1] [nvarchar](150) NOT NULL,
	[address_2] [nvarchar](150) NULL,
	[city] [nvarchar](50) NOT NULL,
	[state_code] [nvarchar](50) NULL,
	[country_code] [nvarchar](50) NOT NULL,
	[zipcode] [nvarchar](15) NULL,
	[latitude] [nvarchar](50) NULL,
	[longitude] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[hotrate] [bit] NOT NULL CONSTRAINT [DF_hotel_list_TEMP_hotrate]  DEFAULT ((0)),
	[video] [bit] NOT NULL CONSTRAINT [DF_hotel_list_TEMP_video]  DEFAULT ((0)),
	[overview] [bit] NOT NULL CONSTRAINT [DF_hotel_list_TEMP_overview]  DEFAULT ((0)),
	[reviews] [bit] NOT NULL CONSTRAINT [DF_hotel_list_TEMP_reviews]  DEFAULT ((0)),
	[map] [bit] NOT NULL CONSTRAINT [DF_hotel_list_TEMP_map]  DEFAULT ((0)),
	[price_band_code] [nvarchar](50) NULL,
	[star_rating] [int] NOT NULL CONSTRAINT [DF_hotel_list_TEMP_star_rating]  DEFAULT ((-1)),
	[low_rate] [decimal](10, 2) NULL,
	[currency] [nvarchar](5) NULL,
	[description] [nvarchar](max) NULL,
	[amenities] [nvarchar](1000) NULL
) ON [PRIMARY]

quote:

---

[SqlServer5 [1435]]
Error: The attempt to send a row to SQL Server failed with error code 0x80004005.



[DTS.Pipeline]
Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "SqlServer5" (1435) failed with error code 0xC02020C7.
The identified component returned an error from the ProcessInput method.
The error is specific to the component, but the error is fatal and will cause the Data Flow task
to stop running. There may be error messages posted before this with more information about the failure.



[SqlServer5 [1435]]
Error: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred.
Error code: 0x80040E14.
An OLE DB record is available.
Source: "Microsoft SQL Native Client"
Hresult: 0x80040E14
Description: "The statement has been terminated.".
An OLE DB record is available.
Source: "Microsoft SQL Native Client"
Hresult: 0x80040E14
Description: "Invalid data for type "numeric".".


[FlatFile1 [1012]]
Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.



[DTS.Pipeline]
Error: SSIS Error Code DTS_E_THREADFAILED.
Thread "WorkThread0" has exited with error code 0xC02020C7.
There may be error messages posted before this with more information on why the thread has exited.



[DTS.Pipeline]
Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "HOTEL_LIST1" (1012) returned error code 0xC02020C4.
The component returned a failure code when the pipeline engine called PrimeOutput().
The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
There may be error messages posted before this with more information about the failure.



[DTS.Pipeline]
Error: SSIS Error Code DTS_E_THREADFAILED.
Thread "SourceThread0" has exited with error code 0xC0047038.
There may be error messages posted before this with more information on why the thread has exited.

---

id	brand	name	address1	address2	city	state	country	zip	latitude	longitude	phone	online_bookings	hotrates	video	brochure	overview	reviews	map	price_band	star_rating	star_source	amenities	popularity_grade	collections_grade	desc	change_date	lo_rate	hi_rate	currency	sabre_id
10226698	LM	Imperial Aryduta Hotel N Cou	401 Bulevar Jend Sudirman Lip		Jakarta		ID				62-21-5460-101	Y	N	N	N	Y	N	N					F	X	Imperial Aryaduta Hotel And Country Club Is Just Minutes Away From Jakarta S Central Business District  The Imperial Century Hotel And Resort Is A Tranquil	08/18/2007 04:01:48	11999769192.00	13599738417.60	IDR	66249