July 16, 2012 at 10:16 pm
Hi,
I am using sql server 2008 r2.
i have developed 2 packages.
first i had created xml config file in first package.
in this 3 oledb conections is there.
seccond package also i am using same config file.
but in this package i am using only 2 oledb connection.
when i had run that job first package was sucessful completed.
but second package was showing congif file related error.
error: third connection is not there in second package.
can you tell me how to solve above error.
July 17, 2012 at 1:10 am
In the second package, you must declare the third OELDB connection athought the package doest not use this connection.
This is a disavantage of SSIS 2008 if you use the same configuration XML for your packages. However, this is fixed in SSIS 2012.
You can refer info from
http://www.sql-server-performance.com/2012/ssis-features-sql-server-2012/
July 17, 2012 at 4:38 am
Thanks for give replay.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply