Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SSIS OLE DB Provider for Teradata - Query timeout expired
213 views
Skip to first unread message
Mike Rodewald
Apr 11, 2012, 1:12:15 PM4/11/12
to
How can I change the SSIS query timeout setting for OLE DB Provider for Teradata?
I've seen comments around that this may be a Teradata timeout setting. Is that specific to OLE DB connections?
The query below times out in 30 seconds when executed from SSIS via OLE DB Provider for Teradata as SQL Command or SQL command from variable.
When executed from SSIS through the Attunity driver for Teradata (or from Teradata SQL Assistant) it returns in about 2 minutes.
In the end, I'd like to use SQL command from variable so I can modify the date value. The Attunity driver doesn't have the SQL Command from variable option.
My last choice would be to include the SQL Command property in the config file and change that every time I pull new data.
Using:
SQL Server 2008 R2
SSIS v10.50.2500.0
Teradata 13
SELECT org.org_level_03_Id,opdc.Org_Id,opdc.Product_Id,opdc.Day_Dt,Selling_UOM_Id,opdc.Total_Net_Cost_Amt,opdc.Cost_of_Sales_Amt,opdc.Fees_Amt,opdc.Shrink_Amt,opdc.Funds_Amt,opdc.Primary_Cost_Method_Type_Id,opdc.Last_Update_Ts,opdc.Row_Load_Ts,opdc.Source_System_Id FROM MerchSales_App_AV.OrgProductDayCost opdc INNER JOIN MerchSales_App_AV.FlatOrgHierarchyASIS AS org ON org.Store_id = opdc.Org_id AND org.Org_Hierarchy_id = 203 WHERE COALESCE(opdc.Last_Update_Ts,opdc.Row_Load_Ts) >= CAST('2012-04-08 09:00:01' AS TIMESTAMP(0) FORMAT 'YYYY-MM-DDBHH:MI:SS') AND org.Org_Level_03_Num IN (30,60)
I've seen comments around that this may be a Teradata timeout setting. Is that specific to OLE DB connections?
The query below times out in 30 seconds when executed from SSIS via OLE DB Provider for Teradata as SQL Command or SQL command from variable.
When executed from SSIS through the Attunity driver for Teradata (or from Teradata SQL Assistant) it returns in about 2 minutes.
In the end, I'd like to use SQL command from variable so I can modify the date value. The Attunity driver doesn't have the SQL Command from variable option.
My last choice would be to include the SQL Command property in the config file and change that every time I pull new data.
Using:
SQL Server 2008 R2
SSIS v10.50.2500.0
Teradata 13
SELECT org.org_level_03_Id,opdc.Org_Id,opdc.Product_Id,opdc.Day_Dt,Selling_UOM_Id,opdc.Total_Net_Cost_Amt,opdc.Cost_of_Sales_Amt,opdc.Fees_Amt,opdc.Shrink_Amt,opdc.Funds_Amt,opdc.Primary_Cost_Method_Type_Id,opdc.Last_Update_Ts,opdc.Row_Load_Ts,opdc.Source_System_Id FROM MerchSales_App_AV.OrgProductDayCost opdc INNER JOIN MerchSales_App_AV.FlatOrgHierarchyASIS AS org ON org.Store_id = opdc.Org_id AND org.Org_Hierarchy_id = 203 WHERE COALESCE(opdc.Last_Update_Ts,opdc.Row_Load_Ts) >= CAST('2012-04-08 09:00:01' AS TIMESTAMP(0) FORMAT 'YYYY-MM-DDBHH:MI:SS') AND org.Org_Level_03_Num IN (30,60)
0 new messages