Easily solved, yes, but that doesn't explain why I got the error message in the first place.  All I did was a SELECT...INTO.  Nothing else except using that table in...

My thoughts are 3-4 years (preferably 4) between releases is a good idea.

Consider this: Not everyone is going to jump on the upgrade bandwagon.  Of those who do, 85% of...

Given what Steve Jones has said in another thread, I'm planning on taking 431 first before I take 447.  Apparently 431 is the hardest of the Admin exams. I figure if...

Well, I support the production environment (Data fixes, performance monitoring, backups, etc.).  I support the Dev/Test/QC environments (backups, restores, releasing T-SQL code created by our development team).  I do schema...

Steve,

I thank you for your thoughts on that one.  I was going to take 431 first and the 447 (the upgrade).  I've been working with SSMS for the past 6+...

I have to wonder if someone from Transceder isn't working with the MS crew that they can be that good with the exams and not get sued.  Surely MS would...

Good catch on the typos!  Thanks for pointing them out.

I apologize for not mentioning the Security Settings.  I re-create this project 3 times to make sure my code worked consistantly and...

BTW, thank you both for your replies.  I do appreciate them.

Bob,

Actually, I finally figured out what the problem is.  It isn't SSIS (per say), but the Excel connection to SSIS.  Even if I pull a sheet with data first, each...

Honestly, I haven't actually worked Visual Basic Express, just Studio 2005.  Google has lots of information about SQL Server Express and the SMO object, but I can't seem to find...

Thanks, Mohammed!  You are a gem! @=)

Unfortunately, it doesn't help.  I am using SSIS in SQL 2005, not DTS in SQL 2000.  And the only other explanation I found that's similar to this is talking about...

I know a lot of people who do the Ronco thing, "Set it and forget it" when it comes to backups.  The job works perfectly and the backups from the...

Okay, I found what I wanted finally in the Advanced Editor for the Excel Source objects (Advanced Editor, Input & Output Properties -> Excel Source Output -> External Columns).  But...

Ah.  I didn't realize someone had already posted the issue.  Sorry about that.

My take on it is this is one of those things no one thought to check.  After all,...