SQL Server Performance

Error When Deploy SSIS Package to MSDB

Discussion in 'SQL Server 2005 Integration Services' started by pipo_tu, Jul 16, 2006.

  1. pipo_tu New Member

    Help Me I've error when deploy SSIS package to MSDB with deployment wizard error like this


    ===================================

    Could not save the package "C:Documents and SettingsaunMy DocumentsVisual Studio 2005ProjectsImportCommitteeImportCommitteeinDeploymentIMPORT_FS_DATA.dtsx" to SQL Server "(local)". (Package Installation Wizard)

    ===================================

    The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). The SQL statement that was issued has failed.


    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
    at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
    at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)

    ===================================

    The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). The SQL statement that was issued has failed.


    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
    at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)


    Thanks for your help
  2. satya Moderator

    What is the service pack level on SQL &SSIS?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page