Could not load file or assembly 'Microsoft.SqlServer.TxScript, Version=10.0.0.0
My environment is SQL2008R2 (SP1). I have SSIS/SSAS/SSRS installed on separate servers from my database engine instances. Up until the last two days I was running my database engine on an old SQL2008 cluster that had originally also hosted the SSIS/SSAS/SSIS services. I am now running on new servers, where only the database engine has been installed. Subsequent to that move I have started receiving the following error stub (i.e. individual SSIS package steps fail with this error; the error differs in specifying the step failing). In the end, my question is what services, if any, do I need running on the database engine cluster (a Windows 2008R2 SP1 cluster) as part of the database engine instance in order to call the DTSX packages on the SSIS/etc. application server? Thanks, Al Description: The managed pipeline component "Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" could not be loaded. The exception was: Could not load file or assembly 'Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified..
November 20th, 2012 1:57am

you need to have SSIS installed on the machine that you run packages, for installing SSIS you need to check Integration Services in installation sql server mediahttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2012 1:59am

you need to have SSIS installed on the machine that you run packages, for installing SSIS you need to check Integration Services in installation sql server mediahttp://www.rad.pasfu.com
November 20th, 2012 2:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics