March 23, 2010 at 9:40 am
Here is the hierarchy of packages in the data warehouse integration services project
Load_Data_Warehouse.dtsx
EXECUTE PACKAGE: Load_Daily_Dimensions.dtsx
EXECUTE PACKAGES: Load_Dim_Child
Load Dim_CP_registrations
Load Dim_Age
These 3 packages contain an Execute SQL Package.
DelayValidation for the child packages are set to false (Load_Dim_Child
Load Dim_CP_registrations and Load Dim_Age)
ExecuteOutOfProcess = True for the master Load_Data_Warehouse
ExecuteOutOfProcess = False for the children
When I execute it runs through Load_Dim_Child and then fails at Load_Dim_Age but the error just says fail. Is there anything Im missing or should be looking for. Im really struggling with this. Everything is being dealt with on the same Server.
April 6, 2010 at 3:46 am
Bit more information
I have a feeling it might be because of the connections ADO-NET and OLE DB
Dim_Child and Dim_Age are both OLE DB connections because no parameters are involved
Dim_CP_registrations has an ADO-NET connection because it has @Financial_Year as a parameter.
Maybe this is causing the issue but I dont really know where to check
Debbie
April 6, 2010 at 4:13 am
Oh well I sorted all this out and its still failing at the second package and I cant think why.
HEYLP :crazy:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply