OMG it works! Genius. You're the best!!! EVER. Thank you.

Accidentally posted twice

-- SAMPLE COST DATA

DECLARE @COST TABLE (I_Matl varchar(5), I_Plant varchar(4), D_Costing int, M_Totl_Cost float)

INSERT INTO @COST VALUES ('95583','0141', 20110101,123.29)

INSERT INTO @COST VALUES ('95583','0141', 20110201,191.33)

INSERT INTO @COST VALUES ('95583','0141', 20111101,178.45)

INSERT INTO...

Sorry. I thought the request was to post the sample data. I can do that.

Data from Cost Table - tbl_Stag_Cost

I_MatlI_PlantI_Cal_YrM_Totl_COGSM_Fixed_COGSM_Var_COGSI_CurrD_Costing

95583014120111261.19128.231132.96USD20110101

95583014120111276.85135.161141.69USD20110201

95583014120111305.64135.161170.48USD20111101

95583014120121196.07106.901089.17USD20120101

95583014120131153.2680.241073.02USD20130101

95583014120131153.2680.241073.02USD20130701

95583014120141162.6379.131083.50USD20140101

Data from Primary Transaction Table - tbl_Stag_Trans

I_Bill_NbrI_Bill_ItemD_BillI_MatlI_PlantI_Doc_CurrM_Spec_PriceI_Curr

0091032577420120104955830141USD4096.51USD

0091032565320120104955830141USD13971.27USD

0091017091120111021955830141USD4236.72USD

0091017399420111024955830141USD4096.51USD

0090966415420110228955830141USD2048.26USD

0090967913420110307955830141USD4096.51USD

0090967915320110307955830141USD4096.51USD

0090968213420110308955830141USD4126.99USD

0090968715420110310955830141USD3762.76USD

0090969390420110315955830141USD2048.26USD

0090969446420110315955830141USD4096.51USD

No time. Date format is yyyymmdd.

Can I assume that it's just this particular component since all other scheduled SSIS packages run successfully?

The connection to the data source works fine. This is the issue I'm now having.

I'm running SQL Server 2008 R2 SP2 and I have scheduled other SSIS packages all...

The connector is installed on the server. The only thing I didn't do was to reboot the server. I didn't think that was necessary.

I solved my issue. I created an Execute SQL Task that generates a temp table. In the event the Data Flow process fails, I have another SQL task...

Thanks for the quick response. Unfortunately, my source is an SAP BW Open Hub. I was hoping there was a to run the first part of my process...