Hello, I have created a job which I pass two variables through as follows:
The "UnisoftVB" DTS contains the following ActiveX script:
The form in the access database when opened runs a lot of VB (which I didn't write) and ultimately updates a table with up to the most recent data.
When I run the job it is successful but it happens far too quickly which made me suspicious that it wasn't working. The table doesn't contain the most up to date data.
I have checked my DTS by chaning the global variables and declaring them there instead and it does work.
I wondered if anyone could tell me why my Job doesn't seem to run my DTS correctly????
Please help Jo
Its a stab in the dark but you say the code runs when you open a form but the script above is called PressButton I know its only its name and it doesnt necessarily have to be associated with a button press but ...
answered Feb 12, 2010 at 01:01 PM
OK, in a new SSIS package add a script task to the Control Flow tab. Set the language to Visual Basic (it may be Visual C# by default). Edit the task. Click the Edit script button. In there you will find a section of code that is Sub Main. Paste this after the comments but before the DTS.TaskResult .. line
Click File|Exit and then OK the dialogs until you get to the Control Flow editor. Press F5. You should get a message box come up with a message.
Now you need to get your Globalvariable value into a similar message box and you can check how your script is working.
answered Feb 15, 2010 at 03:53 PM