Search results for query: *

Do you have or can advice examples? Thanks

I have DTS Package,which I need to migrate to SSIS. In my DTS I have 3 ActiveX scripts: one creates file with different name every day(Date Extension like FileName_YYYYMMDD). Then data transformation transform data from stored proc to this file. Second one creates another file (title) with...

Thanks Paul very much for your time and help

I found the problem. I had evaluate as expresion property set as true. After I fixed it it is correct

Thanks Paul, I have the same. I have FileName as ReadOnlyVariables and FileFound As ReadWriteVariables. Also in Script Task Expressions I have @[User::FileFound] On a Package Level I have Variable FileFound on User NameSpace without any value in it, declared as String. Code is exactly as I...

Sorry Paul for the confusion and thanks for your help. But even in my first message I stated that I am trying to migrate ActiveX Script in 2000 to ScriptTask in SSIS 2005. I created Package Scope variables FileName and FileFound as String. In ReadWriteVariables I put FileFound and in expression...

Yes, this is a ReadWrite Variable. So I guess I need to lock it, right?

I had it as string, but it still does not work even I changed to boolean. Should I lock the global variable before I assign value to it?

How can I assign value to Global variable in SSIS using ScriptTask. The statement Dts.Variables("FileFound").Value = "1" gives me an error. Any advice? Should I lock variable before assigning value and if yes what would be the statement?

Paul, Thanks very much, it is so simple and it works!

In DTS I used workflow ActiveX script to determine File Existence and depends on the result run one of the following tasks. I had a global variable with FileName. Then in ActiveX script I had script like this: Function Main() Dim oFSO, sFileName sFilename =...