Steve Jones - Editor (5/25/2010)

---

No, this new table is only for the ETL movement. Once the data is moved, it isn't needed, but it is needed in order to ensure...

Steve Jones - Editor (5/25/2010)

---

There's no good way to do this. I've done what you suggested, but it's the same as what Stewart wrote. You need to create a table...

No. However I figured out another issue today. The identity columns are being used as the Primary Key on these tables and there are FK relationships setup with...

Anyone?

I have the exact same issue. Hopefully someone will respond soon.

Nevermind, I figured out that I just needed to restart the SQL Agent Service and it stopped trying. 😛

george sibbald (5/4/2010)

---

thanks for sharing.

but of course you now have an index that offers no performance gain on selects but will need to be maintained on updates/inserts and double(?) the...

Well, I tried in our dev environment and it appears that the query used the non-clustered covering index over the unique clustered, however, both indexes provided the exact same statistics....

Thank you Ray for going through all of that. I truly don't know why I didn't think to just test it on a dev server. I appreciate your...

Jeff Moden (5/3/2010)

---

SQLJocky (5/3/2010)

---

Is there anything that can tell me how long it might lock down my table if I add a new index? We are running 2005 Standard...

Phil Parkin (4/30/2010)

---

In the part where you specify what the field will contain, just add some literal text as your expression, eg

"Server1"

This will then be available to you in the...

Hehe, yes I remember how to do that. My question is more around how to tell it that it should derive a column that doesn't exist in the flat...

Thank you for responding. I have looked at using that and am new to SSIS. Would you be able to shed some light on how exactly I would...

Thank you! It worked like a charm (of course) and I've learned something in the process! 😀

Hmm...my Data Flow Path Editor only shows General, Metadata, Data Viewers. I don't see anywhere that would allow me to transform the data.