Archives of the TeradataForum

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

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

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>>