INI File

[franck326]

Hello,

Like as I explained in my previous thread I decided to update SQL Server Connection Properties from the DTS Package with INI File.

The problem is the location of the file which is actually stored on the drive D: of the 3 SQL servers (D:\test.ini as example).
When the DTS runs the file is not found by the system which is looking for the file on the D: of the user's PC or the D: of the network server where the binary of the application is registed on. I don't know exactly where it is looking for but never on the local server in fact.

Is it possible for the location written in the DTS package for the INI file to map a network drive on the local SQL server ??? I can't use the name of the SQL server to make the reference to the INI file (ex : \\server1\toto\test.ini) because I don't want to modify each of them according to the SQL server where the DTS is registered on.

Each SQL server has a drive D so the INI files can be located on them.

Thanks in advance and sorry for my english