December 10, 2008 at 7:19 am
Hi,
I have a DTS package written to take data from an a series of Oracle database tables to a series of tables in a SQL 2005 database. When I process each table manually the package succeeds, but if I run through a series of tables the package kept failing on two particular tables. By a process of elimination I discovered that a column in one of the Oracle tables called 'Information' was causing the failure. I renamed the column to 'Information_R' and the package then failed on another table with a column called 'AnyOtherInformation'. I renamed this column to 'AnyOtherInformation_R' and the complete load from Oracle to SQL Server completed.
The failure only occurred when the tables where processed together, they succeeded if processed individually. The only way I could get them to load together was to rename the columns mentioned.
Has anyone else come across this type of problem ?
Thanks
Ronnie
December 10, 2008 at 9:37 am
I don't think I've had that happen, but could you provide the error message and schema of the source and destination tables? Also, a description of the DTS package eg. the tasks used would help diagnosis.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply