logging - How to eliminate 'unused output column' warnings in SSIS jobs? -

-

i'm trying rid of spurious warnings in ssis progress log. i'm getting bunch of warnings unused columns in tasks use raw sql work. have data flow responsible archiving data in staging table prior loading new data. data flow looks this:

+--------------------+ | oledb source task: | | read staging table | +--------------------+           |           | +---------------------------+ | oledb command task:       | | upsert history table | +---------------------------+           |           | +---------------------------+ | oledb command task:       | | delete staging table | +---------------------------+

my 'upsert' task like:

-------------------------------------- -- update existing rows first... update history set    field1 = s.field1     ...   history h inner  join staging s on     h.id = s.id  h.last_edit_date <> s.last_edit_date -- update changed records  -- ... insert new rows insert history select s.*   staging s join   history h on     h.id = s.id  h.id null --------------------------------------

the cleanup task sql command:

-------------------------------------- delete staging --------------------------------------

since upsert task doesn't have output column definitions, i'm getting bunch of warnings in log:

[dts.pipeline] warning: output column "product_id" (693) on output  "ole db source output" (692) , component "read piv_product staging table" (681)  not subsequently used in data flow task. removing unused output column  can increase data flow task performance.

how can eliminate references columns? i've tried dropping in few different tasks, none of them seem let me 'swallow' input columns , suppress them task's output. i'd keep logs clean see real problems. ideas?

thanks!

union - select columns want pass through - delete others.

i thought going address in 2008 version allow columns trimmed/suppressed pipeline.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more