Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Jun 2011 @ 20:49:47 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Selected non aggregate values must be part of associated group
 
From:   Shaibal Chakraborty

I am trying to create a SSIS package which would pull data from Teradata using SQLCommand and insert into a SQL Server database.

Everything is working fine, even when I am parsing or previewing the SQLCommand query at the time of creating the package, the data are retrieve from the Teradata and is shown in table.

However when I am executing the package the following error stops the package to be executed successfully and the error is from the source database i.e. Teradata in my case.

Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "OLE DB Destination" (16)" wrote 0 rows.


However, the query seems to be fine as there is no error while previewing the query at the time of creating the package. Here is the query below:

     select
     a.trans_end_dt,
     b.store_id,
     b.store_name,
     b.legacy_sv_gl_center_num,
     extract(hour from trans_end_time),
     c.product_level_03_desc,
     c.product_level_04_desc,
     c.product_level_07_desc,
     c.product_level_08_desc,
     sum(a.net_sales_amt),
     count(distinct a.rtl_trans_id),
     sum(a.scan_wgt_amt),
     sum(a.scan_qty)
     from svuedw_bv.rtlsaleitem a,
     svuedw_bv.storeasis b,
     svuedw_bv.flatproducthierarchyasis c
     where a.org_id = b.store_id
     and a.product_id = c.product_id
     and c.product_hierarchy_id = 2
     --and product_level_03_id = 4
     and b.store_brand_name like '%FARM FRESH%'
     and a.trans_end_dt between 1110601 and 1110609
     group by
     a.trans_end_dt,
     b.store_id,
     b.store_name,
     b.legacy_sv_gl_center_num,
     extract(hour from trans_end_time),
     c.product_level_03_desc,
     c.product_level_04_desc,
     c.product_level_07_desc,
     c.product_level_08_desc

Here in the query you can see that all the non-aggregated columns are part of the GroupBy clause, hence ideally this error should never be there.

Please help, it's urgent.


Many thanks,

Shaibal Chakraborty
Tata Consultancy Services



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023