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,...

Ginger,

If it makes you feel any better, you're not the only woman who works that way.  #s 1 and 2 describe me as well.  And while I do work with...

I think the most part of the decline is due simply to the effects of the Tech Bust.  We all know there were tons of people in IT that shouldn't have been...

Female sterotyping?  I don't know.

I am the only woman in a 4 person DBA team here at my workplace.  The development team consists of an additional 7 men.  And yet,...

Stephanie,

No kidding!  I had a 6 week contract once for a company who only had developers on staff.  And my very first job was creating translog backups.  They had started...

The only time I usually shrink a database is when I've backed up a Prod DB (set to FULL recovery) and restored it down to a Dev box.  I shrink...

Steve,

Believe it or not, having IT experience period will do much to help you out.  My major problem was not having any professional (read "paid with appropriate job title") IT...

Did you follow the instructions in the Microsoft KB Article? 

If so, are you saying they are still having problems?  What sort of errors are they getting?

This article should help you out.  There are additional permissions on the Server OS that you have to grant in order for non-sysadmin users to launch SSIS.

 http://msdn2.microsoft.com/en-us/library/aa337083.aspx