Thanks Elliott! Yes, we just started using the folders for our SSIS packages, which is really what started this quest. "What are all these packages - are where...

Thanks so much for the quick reply!

Unfortunately I cannot change the table; our home office has complete control over this table. Every night they delete the current contents of...

Thanks for the reply Andy. It is a package-scoped variable, however I had left the 'Value' part of the variable blank. After I entered some sample into the Value...

Excellent article! I have SO much to learn! Question – I want to set up variables to use in a Send Mail Task. I created the variable...

Found the problem - there were two versions of sp 2 for SQL Express '05 - upgraded to the latest and it seems to be working okay now.

Thanks for the...

Thanks for replies!

My OS is Windows NT 5.0 sp4.

I have configured the server:

use master

go

sp_configure 'show advanced options',1

go

reconfigure with override

go

sp_configure 'Database Mail XPs',1

go

reconfigure

go

And created a profile and set it...

Thanks for your reply!

I have deployed them on my vm; they show up in Management Studio under my Integration Server connection - under File System. When I run the...

I have a designated folder that contains my five files, plus one other file that shows up occasionally to prompt me to change rates – other than that there is...

Thanks for your reply!

But I'm running into problems ...

I’ve created my variable, added the Script Task to my Control Flow, and added my variable under ReadWrite. As for...

Good to know performance isn’t an issue either way. Thank you both for your replies.