hmm.. interesting

but when i just run dts from dts window, or from the same VB front end it works ! so i don't understand why i wouldn't have permission to...

well when you install EM, u also install all the needed DLLs. Including some that are necessary to run DTS from a pc that has no EM.

I am not installing...

i thought about that after your previous email, and changed it a root of some of drive. (and deleted from c\temp) still works for me (and i can see its avtually...

assigns value to global variable

DefExpFullPath = C:\xxxx.csv

assigns value to DataSource property of Text Connection to be DefExpFullPath

----

in a previous version (which works for other users) TextConnection was always pointing to...

can't seem to make it work

My first version worked, but after i added dynamic properties

users get error -2147221005

Invalid class string

can they point to users C drive or it has...

like this ?

didn't work..

   Error string:  Error opening datafile: Access is denied.

EXEC  master..xp_cmdshell 'DTSRun /~Z0xBDAD6C87207249AE418680C80C66217DD12F84FE8C153592ADD365456EBFE7A5C3C4E80F86521367169BC4FE599356894188BF7B53417AC84DF6B0DA71885066FE2D34CA912B188AEACC7C7ACA484DE7D6368BD490DD46848F66365E7CF4DFC89B4FEF44C215667E267D5EC3224EF89AB336471064A3411692567E692CB4D91265851FC864F0CBF3F71E01B20796F39015770758BF95993EA7588DD81270C4CD1AC772'

sorry, i don't understand.

if i schedule it it'll run in the scheduled time. I'd like it to run when stored procedure is run