August 16, 2010 at 2:52 am
Hope i can find some help on my problem, it es very rare i think..
I Have migrated several SSIS Packages from 2005 to 2008 and now after making many manual migration steps to it the packages run ok. But one Package that includes 1 Script Component to extract Excel Files to CSV still wontl run as wished, so i recreate the Scipt Component directly in BIDS 2008....for unknown reasens all Component Task works fine, but the Excel Convertor Script throws an exception -> cannot find table 0! i dont know why cause when i run the Package from from within BIDS, all works fine....the problem is from the command line. I also already tried from an SQL Agent Job or SP....the same behavior.
so my question in general, are there basic difference between running a Package from BIDS or from the command line with dtexec? Maybe any prposal...?
August 16, 2010 at 3:05 am
...ok i think my problem comes from 64Bit. the package mode is set to not run in 64bit. now trying to start the package from the command line in x86 mode. hope this works
August 16, 2010 at 3:12 am
so yes, dtexec /X86 Option will help me this time;-)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply