As far as I'm told, an item...

Nevyn (10/17/2013)

---

What should you return if there is no prior record in routing history for that period (ie: item introduced a month later)?

Also, what are you grouping by? Just...

jonysuise (10/17/2013)

---

I think what you want is to query all routing_history rows and show period_month column only if available. This is a left join :

select

p.period_month,r.warehouse_code,r.item_number,r.origin_warehouse_code,r.Fromdate

from

Routing_History r

left join Period...

Ok these are some of the errors I've been getting despite having followed the explanations to the letter

Error 1 Validation error. Data Flow Task:...

larskandersen (9/27/2013)

---

You mentioned that "I set in the expression @Connectstring to the variable I'm filling up with the connectionstring"

Why don't you just set the variable value to your development connection...

I could but like I said when I typed the original post I was no longer @ the workstation so I'll do that tomorrow

SO maybe a new problem maybe a...

Production isn't up yet for the system

Not sure what you mean with padding

I have a separate ole db that points to the config server

ok ,lets for the sake of argument say I've already tried those & to no avail.

I can't find tnsping

The 32 bit of the...

OK so how did I do it, this is a simple step-by-step

1)Load Input folder to variable use execute sql task (User::FileLocation)

2)Load Archive folder to variable use execute sql task (User::ArchiveLocation)

3)Fill...

Tried that and it still executed the flat file destination

OK I found how to do it.

Load the value of the location from the table into a variable.

And then use that variable as an expression for the connectionstring for the...

Does this work and how

GilaMonster (1/16/2013)

---

Could well be that the stats that the query depends on are column stats, not index stats. REbuilding an index only updates the stats associated with that index (and...

That worked

Thank you both for the quick answers