Certification is ok - I consider a tiebreaker these days. I'd suggest VB. If you can do VB you'll find "most" of DTS easy to follow and you wont be...

In Excel you can use a leading apostrophe to make it display as text, but it doesnt seem to work on import - the apostrophe shows up. Seems like there...

Thats cheating! You cant take the test and THEN write the book about it!

Andy

How are you establishing the ado connection, trusted or sql login? I'd double check that line. Maybe post code here so we can see.

Andy

Hello Igor,

You can post questions about the exam in our Certification discussion area. We'll be glad to discuss as long as it doesn't get into anything that would fall under...

Im curious too - tape faster than disk? If it was I probably still would not do it, but would be a nice capability to have.

Andy

I'd suggest that you handle it by creating a stored procedure that you'll run once a day as a job. Once a day means you don't have to keep track...

You can also just shell to the OS and use ren/rename to do the work. Not as good as fso because you have to work harder to trap errors.

Andy

Thats why as interesting as DTS seems, I can never get that interested - seems like so many quirks. The cost of trying to create a super high level environment....

Steve - raw is still supported, look for "Using Raw Partitions" in BOL. Tons of caveats though.

Rob - that makes sense of course, few apps are really platform agnostic -...

Had you recently stopped/started the service?

Andy

Not sure how DTS works, but this is exactly how it works in ADO as well. Even though the operation itself is fine with the ignore dupes option the error...

Take a look at DBCC shrinkfile. If you search our site you'll find several discussion topics and and a script or two that deal with this issue. One shortcut you...

Take a look at 'Alter Table' in Books Online. Adding a column is pretty straight forward. Sounds like you're new to SQL, so you might want to keep this idea...

Bill, didnt get a chance to reply earlier, but the detach/reattach solution is one I've used myself - has the merit of simplicity! It's also very fast.

Andy