Post reply

How to Run excel vba code in SSIS using Script task..Can any one please help

  • January 19, 2012 at 3:54 am

    #391351

    I have a vba code in excel which generates 1000 reports. I want to put that vba code in SSIs and schedule it..Please let me know:-)

  • January 19, 2012 at 9:23 am

    #1435976

    vba transfers quite well to vsa.

    You could copy and paste your vba into the script component and edit there.

    Since ssis script component is crap for debug, I generally test scripts in Access, creating my data inputs and output capture in local tables. Languages are nearly interchangeable.

  • January 19, 2012 at 11:27 am

    #1436092

    What's your VBA code, let us take a look...

    schedule it, you don't really need SSIS for that unless you're doing something else in the package, you could schedule the VBA code itself through windows 'Task scheduler' or even sql agent job.

    but I assume you're doing something else in the package.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply