What can I say, It has avoided some confusion in the past. Mostly from 'Hi, been a long...

What do you mean by 'certain fields determined by KeyItems'? are these input variables, or do you mean that each row determines what will be imported?

I agree with irobertson.

But, that suggestion only works if the Access DB remains connected to the network. If the Access db goes off-site, then you don't have any data.

In...

moosamca (2/18/2010)

---

Please help me write the below query in basic optimized way. Thanks in advance

Query:

====

select b.CallLetters,f.ContractKey,c.DatecontractLineEntered,d.HeadlineNumber,count(a.sk_SalesFact),a.GrossRate

from salesfact a with(nolock), station b with(nolock),DateContractLineEntered c with(nolock),HeadlineNumber d with(nolock),ContractKey f with(nolock)

where a.sk_station...

Very nice ritz,

I learned 2 things here, most importantly that Lookups allow left joins. I don't see it here, so I'll ask: Is the only way to do multiple...

So, by no scripts, do you mean no Objects called 'Execute SQL Task'? or Just specifically 'Script Task'? or something else outside of SSIS?

The source of your problem is...

That error means that you have nvarchar on on one end of the import, and varchar on the other. Change one side either way.

I agree that having the MS people there sounds nice. I, also didn't use them. We are a tiny shop, and things just don't come up that...

I have to laugh,

After seeing all these comments about what should have been implied and what was inferred, I can't tell you the number of times these QotD...

Great explanation Scott, that's very detailed and instructive. Unfortunately it does not address the behavior found by KevinC. Why is not the behavior you describe consistent in a...

I'm not sure I understand the question, but here is a stab.

DBCC CHECKIDENT (YourTableName, RESEED)

This will reset the seed value in your identity column to the current maximum value in...

Gift Peddie (11/30/2009)

---

Dan Guzman - Not the MVP (11/30/2009)

---

I see what your saying, but there is still a step missing. As I understand it, ReportViewer doesn't work in Access,...

I see what your saying, but there is still a step missing. As I understand it, ReportViewer doesn't work in Access, so....

Back to the original situation:

Server is updated Access...

You still have to get the reports 'local' in order to view them. I don't think that installing SSRS on each laptop is the right answer, seems a little...

GSquared (11/30/2009)

---

Dan Guzman - Not the MVP (11/30/2009)

---

The latter, though technically Irish, which, if memory serves is part of England, but my grand parents are probably spinning in their graves...