January 19, 2012 at 3:54 am
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
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
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy