What is the error you get when you make these changes?

We need a better description. What object are you talking about? A connection string? A table name? A column? A stored Proc?

Please clarify and we'll be able to help you...

You need to look at the rest of the output. The line you quoted comes at the very end of the output.

When I'm running in Debug mode via BIDS, I...

MAPI usually has to do with Email. At a guess, I'd say your .bat file is trying to use the old fashioned (and depreciated) SQL Mail from previous versions of...

Want a quick and dirty way of getting an SSIS package for your Access db to SQL Server?

Go into your "Dev" environment on SSMS. Rightclick a database and choose All...

I appreciate it, Terry. Thanks,

YOu can use a "Select Into" to maintain your identity in the new table, but it won't retain PK / Relationship stuff. Suresh is correct. The best way to handle...

Thanks, Adrian. Let me know.

Submitted & waiting for approval. @=)

Though if I see you again at SQL Saturday, I'll tell you in person. @=)

Jeff may disagree with me on this, but here's my take on interviews.

Know your stuff, but if you can't answer the question, be honest about it. Tell the interviewer that...

Did you actually install SQL on the new box as part of a cluster or a standalone server? This is one of the options upon install. If you didn't...

Have you checked the firewalls? Have you tried changing ports on your connection to the ports allowed for SQL Server?

I assume the packages are stored in MSDB on your server - have you run a checkdb on MSDB? The error looks like it is indicating a problem getting...

Interestingly enough, it doesn't get granular on column permissions. Or rather, it does, but it doesn't properly reflect them.

I have a SQL Login which has been granted Select permissions on...

Jack, you're a genius! And yes, as soon as I'm done fiddling and fixing to my satisfaction, I'll definitely post it to the library. @=)

Thanks!