Look at "Reserved Keywords" in BOL I don't see it.

But place in brackets should get around as long as is a column name.

Sorry been a while since I have done. You most likely will run into issues with user accounts referencing the old domain that will need to be dropped and added...

Field poisitions are not random. They on the trnasformation tab. If you have a single transformation for all columns then you pick that transformation and edit it. If you have...

One question first are they all the same table and layout only thing is the connection changes?

Are you using the Export Wizard? If so do you have the SQL 2005 drivers installed.

I know you can Import using 2005 from 2000 but never tried vice versa. And...

So with the light bulb metaphor if the power went out do you assume the outage is the light bulb and thus replace it until you find one that works?...

Sorry I may hav grabbed the wrong one. Just search for "Export DTS" in the site search option looking in discussion groups.

The form seems to see ) as a smirk smiley when on the line first in code fo whatever reason like so

)

if you post code and then go in and put...

Ther have been many discussions on this. Check out this one

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=179518

Nothing yet that I am aware for 2005.

Sorry this really eats me up becuase or personal experience with customers who placed blame on me for things ultimately found to be their issue.

Some folks here have stated they...

I think a lot of folks need to divide themselves from th customers point of view and only consider the system itself. If the system is operating as designed and...

Reading this I a reminded of one thing. A person can in fact hav worked with something all their life and not have one clue about it. I dealt with...

I agree here. But would say bad data doesn't evn count as a bug.

Unfortunately, even thou those folks couldn't get authenticated it is not even a bug because the system...

I feel the issue i going to be directly related to improper plan being cached first and foremost. See if it improves by addin the

WITH RECOMPILE

option just before the...