Thanks.... I was trying to make it more difficult.....:o)

Steve Johnson

Steve, you mentioned in your document that you packaged DTS's..... How???? :o)

Steve Johnson

This is the code that gets generated, not to sure what I need to strip out of this to get where I want to go.....

With ActiveSheet.PageSetup

...

Thanks David that will work great!!!

Steve Johnson

Thanks again for all the info.... It has been very useful.

Steve Johnson

thanks.....

Steve Johnson

Thanks Steve, I just opened up SQL Server 2000 DTS, It has a great example of this...

Steve Johnson

Never mind.... I went into the query builder it validated the query and it works now????? don't really know why but it does.....

Steve Johnson

Thanks.....

Steve Johnson

need to script it, we are having problems with people getting to the data before we have finished validation.

So actually what I need to do is disable the users ability...

I only have 118 files you have 125, I did a search for some of the files and found that they were missing..... Not sure what I am doing wrong...

BOL

Steve Johnson

You wouldn't happen to know the syntax to (kill) a txt file would you???

Steve Johnson

Edited by - Steve Johnson on 10/01/2001 12:40:49 PM

Thanks Andy

Steve Johnson

Do you know if it is using the MDAC for the PC that is being used to setup the linked server or is it using the MDAC for the server??

Steve...