SSIS package with 32 bit Excel connection not working in 64 bit system
hi all,
i have one SSIS package with only one Script task which has VB script 2008, which modifies the excel file(alignment,spacing etc) and saves it.
it workes perfactly with 32 bit BIDS. but same is not working in 64 bit BIDS.
also i deployed the package to the server and then created job with 32 bit run time option.
but still the issue is not solved. i tried using X86 32 bit DTExec.exe nothing works.
please anyone suggest me on this.
Thanks in advance.
TarniTarni
July 3rd, 2011 5:04am
Please check the similar thread..
have look at Todd's blog
Let us TRY this | Mail me
My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 6:05am