Archives of the TeradataForum
Message Posted: Fri, 10 Jun 2011 @ 20:49:47 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|