You could use DTSRUNUI, or the command line options for DTSRUN, to generate the encrypted string for you. That might help in the matching.

The encryption is useful when you are...

When you say it 'runs by executing it', are you actually physically on the box, or running via EM on your workstation? If the latter, then the package is executing...

Well if the value for gvFileLocation is typed correctly, then you have an extra '\' after the server name. It should be,

\\SrvrName\D$\CMSReporting\Data\AHT_Skilled

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point...

Generally, I don't allow developer access to production at all. If they want to see how something works in production they can organise a session with me.

If they're bug fixing...

The script would be VBScript so you could run it from the command line, or set it up in DTS or a Scheduled Job.

I can't lay my hands on an...

38 going on 21, currently working on possible second marriage (don't know if the she can put up with me yet ), no kids, no mortgage.

BTW, can...

Ok, so for the moment, create a global variable. Set the value of the global variable to the file you want.

Add a dynamic properties task to the package.

Click Add...

Select...

If you don't want to shell out for an off-the-shelf auditing package, then msinfo is probably a good option.

You can run it from the command line to produce a report....

Generally, I'm in EM and QA all the time but tend to work mostly in QA. Lately I've been working more and more with mssqlxpress.

Have used Embarcadero's Change Manager in...

Ok here goes ...

Farm hand ( at parents farm )

Tractor Driver ( at an orchard )

Ski Hire Cashier

Petrol ( or Gas for you yanks) station attendant

Timber Grading Inspector

Saw-bench tailor-out

Computer Repairer

Ballon...

How do you currently determine which file to FTP?

If you store the file name in a global variable, you can use the Dynamic Properties task to change the appropriate property...

When you use an outer join you can't specify criteria for the right table in the where clause. You need to re-write your query as,

SELECT Student.StudentID,...

You can also do

SELECT SERVERPROPERTY('Edition'), SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses')

Check out SERVERPROPERTY in BOL for a number of other properties that you can see.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and...

Definately check out http://www.sqldts.com, especially DTSBackup2000, great little product.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Maybe we could if your link worked

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface