Thanks for the info 😀

That is encouraging to know that 2005 makes it easier. It is like pulling teeth to get our customer to upgrade. That is why I am stuck with DTS. I...

I am sorry to get in on this discussion late, but the fact you were talking about DTS and FTP caught my attention.

I inherited a SQL Server 2000 database running...

Fantastic! Thank you!

Haroon,

Thanks for taking the time to share your code with me! I am grateful 🙂

What I am attempting to do...

Haroon,

Rog,

Where do I find info on this "RAC" utility. Is it 3rd party?

Thanks,

If I understand correctly, if I went to Windows Authentication with my current MS-Access front-end, I could:

- eliminate having to have a DSN

- not have to pass the SA UserID...

I would like to use trusted connections, but eventually, they want to blow away the MS-Access front-end and go to a web front-end. The CM board would not take kindly...

Look at your VBA code. Do a find on the word "execute". Somewhere in that region of the code is a section where you are given the choice of loading...

Hans,

I recommend the following:

1) Create a Package Level Global variable for both the server AND the database.

2) At the beginning of your process, add a "Dynamic Properties Task"

3) In the...

Thanks for your help! 

Great! ... I will give it a try!   Thanks!

I was trying to avoid that because I wasn't sure how to pass variables between packages.  Can you pass Global Variables between packages?

How does that work?

Thanks for trying!