Hi, I've created a SSSIS dtsx package that should clean a xls file (with interopp excel dll) and then fill it again accessing to my database. The problem I've is that I'm obtainning these errors:
Error: 0xC0202009 en INF_SEG_INSTAL_SERVEIS_LOT_C1, Administración de conexión "Administrador de conexión con Excel 1": Código de error SSIS DTS_E_OLEDBERROR. Error de OLE DB. Código de error: 0x80040154.
Hay un registro OLE DB disponible. Origen: "Microsoft OLE DB Service Components" Resultado: 0x80040154 Descripción: "Clase no registrada".
Error: 0xC020801C en SQL Query --> EXCEL, Destino de Excel [2036]: Código de error SSIS DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Error de la llamada del método AcquireConnection al administrador de conexión "Administrador de conexión con Excel 1". Código de error: 0xC0202009. Puede que haya otros mensajes de error expuestos anteriores a éste con más información sobre el motivo del error del método AcquireConnection.
Error: 0xC0047017 en SQL Query --> EXCEL, DTS.Pipeline: Error en la validación de componente "Destino de Excel" (2036); se devolvió el código de error 0xC020801C.
Error: 0xC004700C en SQL Query --> EXCEL, DTS.Pipeline: Error al validar uno o más componentes.
Error: 0xC0024107 en SQL Query --> EXCEL: Se produjeron errores al validar la tarea.
Paquete SSIS "INF_SEG_INSTAL_SERVEIS_LOT_C1.dtsx" finalizado: Error.
El programa '[7672] INF_SEG_INSTAL_SERVEIS_LOT_C1.dtsx: DTS' terminó con código 0 (0x0).
I've been searching and the 0XC0202009 Error is a login error. Then I've gone to look my Ole DB Connection and I've the user but not the password. I've add it again, I've tested and it works. Then I throw the dtsx again and the same error appears again.
I've lost my password to access to my database. I've tried to close the Visual Studio 2008 and open again, but the same error. I've created a new Ole Db Connection but success the same.
I've tried with this link: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/11/10/ssis-error-code-dts-e-oledberror-an-ole-db-error-has-occurred-reasons-and-troubleshooting.aspx but I have achieved nothing.
Any idea what should I do? Thanks.
Ever than a programmer makes an extra hour god kills a kitten
Connection manager passwords don't get saved in the package for security reasons.
If you wish to save the password try setting the ProtectionLevel property of the package to EncryptSensitiveWithPassword. This setting uses a password for encryption and is used to encrypt the connection manager password.
Failing that, you could store the full connection string in a golbal variable and use and expression to overwrite the full connection string of the connection manager. Although the password would now be visible in plain text.
If you wish to save the password try setting the ProtectionLevel property of the package to EncryptSensitiveWithPassword. This setting uses a password for encryption and is used to encrypt the connection manager password.
Thanks! this is what I did need, thanks for your help. I had thought on do it with a global variable but it isn't a good idea. Thanks again!
Ever than a programmer makes an extra hour god kills a kitten
kilofafeure
Participant
1507 Points
752 Posts
SSIS dtsx Package don't store my SQLServer Password
Jan 18, 2013 11:33 AM|LINK
Hi, I've created a SSSIS dtsx package that should clean a xls file (with interopp excel dll) and then fill it again accessing to my database. The problem I've is that I'm obtainning these errors:
I've been searching and the 0XC0202009 Error is a login error. Then I've gone to look my Ole DB Connection and I've the user but not the password. I've add it again, I've tested and it works. Then I throw the dtsx again and the same error appears again. I've lost my password to access to my database. I've tried to close the Visual Studio 2008 and open again, but the same error. I've created a new Ole Db Connection but success the same.
I've tried with this link: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/11/10/ssis-error-code-dts-e-oledberror-an-ole-db-error-has-occurred-reasons-and-troubleshooting.aspx but I have achieved nothing.
Any idea what should I do? Thanks.
paulbentley
Member
588 Points
104 Posts
Re: SSIS dtsx Package don't store my SQLServer Password
Jan 18, 2013 01:24 PM|LINK
Connection manager passwords don't get saved in the package for security reasons.
If you wish to save the password try setting the ProtectionLevel property of the package to EncryptSensitiveWithPassword. This setting uses a password for encryption and is used to encrypt the connection manager password.
Failing that, you could store the full connection string in a golbal variable and use and expression to overwrite the full connection string of the connection manager. Although the password would now be visible in plain text.
kilofafeure
Participant
1507 Points
752 Posts
Re: SSIS dtsx Package don't store my SQLServer Password
Jan 21, 2013 07:05 AM|LINK