Save a DTS Package dynamically

[mapfax]

I've had problems setting and retaining global variables dynamically in DTS Package properties called from a SP. I now know my problem lies with 'saving the package' after the variables have been set.

Does anyone know how I can achieve this dynamically on/before completion of the package?

I am changing values for importing filenames and changing the destination table according to the value of those filenames.

 

[mapfax]

I think I've found what I am looking for.

I need to use the 'SaveToSQLServer' method on the DTS package object. For example:

--
Set oPKG = DTSGlobalVariables.Parent
oPKG.SaveToSQLServer "(local)", "","", DTSSQLStgFlag_UseTrustedConnection
--

Although I am using a trusted connection, I think I am going to have more work figuring how nonsysadmin users run it from a SP within an Access project. Later!

Would appreciate comment if I am wrong. Thanks.