I believe a downgrade with databases attached was not a wise move; cf. --

http://www.sqlservercentral.com/Forums/Topic1172742-146-1.aspx#bm1172885

Your best choice is to reinstall Enterprise, if you can, reattach the databases and...

Typically, the anchor and common denominator of the solution that contains these types of projects is the database project. It was not mentioned but I assume it would be...

My point, exactly 🙂

I think acceptance of renewable energy in IT runs into two problems.

First, it requires a long term investment but no one is sure what the price of electricity will be...

project review

SSIS does more than DTS. You will appreciate these "hidden" features when you have to copy say 2B rows: data flow task will handle it, INSERT ... SELECT...

I graduated as an aeronautical engineer and was hired as an aerodynamist. On the first day on the job I was switched from "70 percent aerodynamics, 30 percent computers"...

I'll be here. I am on the Pacific Time - please expect a reply after 4 PM GMT.

Have a great weekend.

What version and edition of SQLS are you running?

Also, ity would help if you could attach the package.

GSquared (11/4/2011)

---

. . . Nothing wrong with building your own .NET solutions, but frequent breaks in an SSIS package should be cause for re-examination of how the package was...

I love BIDS, but I have a gripe: it is available only in VS2008, not in VS2010, and it forces me to keep both versions side by side.

I am looking...

SQLRNNR (11/3/2011)

---

Teach-in

Exactly - it threw me for a...

Overfed

rfr.ferrari (11/2/2011)

---

good question, i answered correctly!! but in your next question, define the sql server version if is 2k8, 2k5, 2k0!!!

remember, 2k0 only have triggers of FOR, AFTER and INSTEAD...