Thanks again Graham.

The user running the SQLExpress service was Network Service. I couldn't figure out how to grant Network Service the rights to that file specifically, but it must be part...

ALZDBA nailed it - the file was in his My Documents folder which the SQL Service account did not have access to. He moved it and it worked.

Thanks everyone!

DTXCF

Sounds like fun! I'll try that too and let you know how it went.

I forgot about sqlcmd (formerly osql and isql):

http://msdn.microsoft.com/en-us/library/ms170572.aspx

sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\QueryOutputGoesHere.txt

Thanks for the reply - I'll play around with the script task and see what I come up with.

Thanks Graham.

I got the Developer edition installed and it seems to be working great on my XP Pro laptop. I haven't tried out Profiler yet but I'm sure I...

Thanks.

I actually have an MSDN subscription so I'll try downloading the developer edition.

Thanks for the tip!

DTXCF

I will certainly appreciate it if you decide to share your findings. I'll keep looking myself on my end and do the same!

I think i see what you're talking about - the AccessMode property.

Thanks for the tip - I'll read up on the conditional splitting you referred to.

I don't think you *can* share a config file across multiple packages. My client's SQL DBA is a guru and he didn't complain when I gave him 4 copies...

Thanks again Frank.

I'm really not trying to be a pain here but I'm having some serious learning-curve issues.

My project has 4 packages in it. Aren't I supposed to be...

By the way I think I figured out the connection between Data Sources and connection managers - please tell me if I'm right:

You create Data Sources at project level. ...

Thanks Frank. I read that thread and several of the links on other sites including MSDN.

I found where to set the package to DontSaveSensitive and I stop getting the...