ssis - It requires Enterprise Edition (64-bit) or higher -
ssis - It requires Enterprise Edition (64-bit) or higher -
i'm running sql 2012 standard edition , visual studio 2010 within virtual server , i'm running bundle via sql server job , next error:
06/17/2014 16:35:57,a_e,error,,x,a_e,,,the job failed. job invoked schedule 17 (a_e). lastly step run step 1 (a_e).,00:00:19,0,0,,,,0 06/17/2014 16:35:57,a_e,error,1,x,a_e,a_e,,executed user: nt service\sqlserveragent. microsoft (r) sql server execute bundle utility version 11.0.2100.60 64-bit copyright (c) microsoft corporation. rights reserved. started: 16:35:57 error: 2014-06-17 16:36:15.87 code: 0xc00470fe source: info flow task 1 ssis.pipeline description: fuzzy lookup cannot run on installed edition of integration services. requires enterprise edition (64-bit) or higher. end error error: 2014-06-17 16:36:15.87 code: 0xc00470fe source: info flow task 1 ssis.pipeline description: fuzzy lookup 1 cannot run on installed edition of integration services. requires enterprise edition (64-bit) or higher. end error error: 2014-06-17 16:36:15.87 code: 0xc00470fe source: info flow task 1 ssis.pipeline description: fuzzy lookup 2 cannot run on installed edition of integration services. requires enterprise edition (64-bit) or higher. end error dtexec: bundle execution returned dtser_failure (1). started: 16:35:57 finished: 16:36:15 elapsed: 18.236 seconds. bundle execution failed. step failed.,00:00:19,0,0,,,,0
the bundle runs fine in bids when remove fuzzy lookup bundle package works via sql server job don't error above.
thanks
below transformations supported enterprise edition.
persistent (high performance) lookups data mining query transformation fuzzy grouping , lookup transformations term extractions , lookup transformationsyou can build , test ssis bundle using enterprise-edition-only components, cannot execute bundle outside sql server info tools environment.
check this official sql server edition comparing article. have of this thread well.
ssis
Comments
Post a Comment