Neither one of these statements work.  The first one doesn't recognise givenName and sAMAccountName.

Update DT_Users

SET givenName = DT_Users.Firstname, sn = DT_Users.LastName,

company = DT_Users.Company, title = DT_Users.Title, mail = DT_Users.Email

FROM...

Thanks, that's worked.  However the script is not doing what I want it to do.

INSERT INTO DT_USers(Login, FirstName, LastName, Company, Title, Email)

SELECT sAMAccountName, givenName, sn, company, title, mail

FROM OpenQuery(

ADSI,'<

I get an error message when I run the following script

Server: Msg 446, Level 16, State 9, Line 2

Cannot resolve collation conflict for equal to operation.

INSERT INTO DT_USers(Login, FirstName, LastName,...

Thanks for that but...

I'm a little confused with ADSI,';(&(objectCategory=Person)); Is this instead of or as well as ADSI,'<LDAP://Server/OU=User Accounts,DC=company,DC=com,DC=au>;(&(objectCategory=Person));

sAMAccountName, givenName, sn, company, title, mail,

adspath;subtree')

I done

INSERT INTO DT_USers(Login, FirstName,...

I can't thank you enough Jamie, I was going insane over this.

Thanks Heaps

O.K I've completely stuffed it now, it's not even changing the name of the file in the test destination. Before it but the date and time on the end now...

I've been having a lot of problems posting lately.  I hit "Post Reply" and deletes everything I just wrote, so please bear with me.

It seems to me it is the...

Thanks, that worked perfectly, you legend.

Just another question (I'm drawing a blank at the moment) I want to insert this data on a scheduled basis where the sSMAccountName is equal...

This is becoming quite the project isn't it

O.K here's the lastest problem.  It seems to be dumping files properly.....but (you knew there has...

Well that makes sense.

I've commented the messages out and it runs fine until I run the whole thing has a schedule again.  This is the error message:

DTSRun:  Loading...   DTSRun:  Executing...  ...

Wow, that's awsome.....thanks

It may take me a while to go through all of this, but thanks heaps

Don't you hate that

The ActiveX package now works whhoooohhoooo ........but

I run the package manually and...

Gees I felt like a goose then, but I've changed it and it still doesn't work, this is the exact error message:

Error Source : Microsoft Data Transformation Services (DTS) Package

Error...

O.K, the only line that seem so have a problem is:

DTSGlobalVariables.Parent.Connections("Test File (Destination)").DataSource = "\\sun\kris\I52_Invoice" & dtstr & '.txt'

Everything else seems to run fine.

Again, thanks heaps

Thanks sooo much for your help (and patiance :-))

I have changed it to the following and it says there is an error on line 7:

Function Main()

Dim dt, dtstr

dt = Now

dtstr...