Our nightly datawarehouse update processing is periodically failling on an
irregular basis. No useful errors in Windows logs, SQL logs, or SQL Agent
logs. Setting up a table to capture DTSErrors find the following error
message "Unable to prepare the SSIS bulk insert for data insertion for <>
table. Datacode = -1071626267".

Error occurs during the download of the first in a sequence of tables from
an AS400. We are a small shop so the error is not found until start of next
business resulting in an interuption of service for our end-users. A manual
restart of the workflow always runs to completion.

Running on a Windows 2003 R2 machine with SQL 2005 SSIS.

Queried the internet and Technet. Unable to find anything that applies.
Any ideas on how to approach?
--
Clint

If you're using SQL Server Destination to do the bulk insert, you cannot use the SQL Server destination in packages that access a SQL Server database on a remote server. Instead, the packages should use the OLE DB destination.

For more information about OLE DB Destination, see http://msdn.microsoft.com/en-us/library/ms141237.aspx .



dworxClint wrote:

Unable to prepare the SSIS bulk insert for data insertion
27-May-10

Our nightly datawarehouse update processing is periodically failling on an
irregular basis. No useful errors in Windows logs, SQL logs, or SQL Agent
logs. Setting up a table to capture DTSErrors find the following error
message "Unable to prepare the SSIS bulk insert for data insertion for <>
table. Datacode = -1071626267".

Error occurs during the download of the first in a sequence of tables from
an AS400. We are a small shop so the error is not found until start of next
business resulting in an interuption of service for our end-users. A manual
restart of the workflow always runs to completion.

Running on a Windows 2003 R2 machine with SQL 2005 SSIS.

Queried the internet and Technet. Unable to find anything that applies.
Any ideas on how to approach?
--
Clint

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Task Parallelism in C# 4.0 with System.Threading.Tasks
http://www.eggheadcafe.com/tutorials...sm-in-c-4.aspx