Thank you for your responses.

I found out from the SQLDTS.com site that this error was due to the Global Variable in the DTS package.

So using the Local Administrator account I...

Just wanted to mention several more things:

1. I didn't think much of the DTS documentation in BOL

2. Brian Knights article about global variables helped me. I used the ACTIVEX object...

Thank you for your reply.

1. I think the connection is valid, because if I hard code the date it works.

2. No, the connection object was not created on another machine.

3....

The error message I am receiving is:

Package Error

Error Source: Microsoft OLE DB Provider for SQL Server

Error Description: Syntax error or access violation

Thank you, I did understand this neat implementation. This is what I think you mentioned in the first post on this discussion, right?

The employee table and the customer or sales...

quote:

---

a users/data/permissions table, and use views to simplify the permissions and the selects.

- Troy King

---

The...

I have been programming in C and Unix for four years before changing to SQL server.

Personally I have always considered the Microsoft training books to be the best to start...