I've get error when I deploy SSIS package with Deployment wizard like this
===================================
Could not save the package "C:\Documents and Settings\aun\My Documents\Visual Studio 2005\Projects\ImportCommittee\ImportCommittee\bin\Deployment\IMPORT_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)
I've ever pass deploy wizard with test program (a little line of code) but when I've deploy with my real code it's return error I've show above
Thanks for your help
Pipope
Hi All -
I'm experiencing the same problem as well. Any solutions?
Thanks.
No comments:
Post a Comment