Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joshrinn
Posting Yak Master
118 Posts |
 Posted - 2012-04-25 : 10:41:15
|
| Error at 1 Month RO [SSIS.Pipeline]: One or more component failed validation.Error at 1 Month RO: There were errors : SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.". (Microsoft.DataTransformationServices.VsIntegration) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-25 : 14:31:21
|
| Check if login 'COF\OJP875' has access to the database which is configured by connection manager Source_Prod7------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-25 : 21:58:11
|
| the element 'dtsconfiguration' has invalid child element 'dtsconfig info'(Microsoft.DataTransformationServices.Design)How can i take care of this issue. I tried posting you questions on your blog but i guess it was not possible. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-25 : 22:36:42
|
| are you using package configuration to set properties of package?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-26 : 06:17:50
|
| Yes I am |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-26 : 10:58:05
|
| how have you set configuration? i assuming you're using xml to store config values------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS