MS says its ignored:

http://msdn.microsoft.com/en-us/library/ms187499.aspx

But:

http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx

CEWII

MS POV:

http://msdn.microsoft.com/en-us/library/aa964127(SQL.90).aspx

Other POV:

http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp

CEWII

farax_x (9/7/2009)

---

Hi,

I need to design database for enterprise solution (office automation software).in this database i have a critical information that i'm not sure put all data in one table or...

Not so sure on that statistic. True of people (such as yourself) who know the architecture of the product and...

You don't really need to use a dataflow to get data into...

stevefromOZ (9/4/2009)

---

For what it's worth, you *can* get SSIS to prompt for data entry, but 1) you shouldn't 2) it's not overtly simple/easy and 3) you shouldn't (get the idea?...

I see that we have at least two seperate problems

1. Wider re-usability

2. 2 similar queries.

So I'll tackle #2 first

But now I am confused since now I have the same sql...

Would love to hear back how it went.

CEWII

You have some of the right stuff, but the first thing is that it will NOT be prompting you for anything, SSIS is a back-end process, it is not now...

Is there some field in the data that reliable shows an update date? If so then keep track of the last date and use it for the query. ...

I have a couple questions myself..

1. How often do you run this process (or will you)?

2. Do you need to pull all 24M records EVERY time?

3. If you need all...

I would guess they were in the original script that created it. You could interogate syscomments and see if it is in the system table (ok view) and I...

Silverfox,

I think that we are talking about the 1%. I think it should be fixed, but I'm not going to get all in a tizy over it. The...

Grant Fritchey (9/3/2009)

---

Elliott W (9/3/2009)

---

I've got kind of an off the wall question, aren't businesses fleeing from states like MA and CA, aren't they even further down than other states...

itamar (9/3/2009)

---

Theres a Third party tool for SQL Version Control, that can do exactly want you need - Randolph, by Nob Hill software

...It shifts the responsibility for versioning from...