I have sql server 2005 as my default instace. i have recently installed sql server 2008 as named instance. I have "employee" table in XYZ(database name) database on ABC(default instance name). i have same table "employee"(exactly same) in XYZ Database on ABC\KATMAI. Now i am trying to load ABC.XYZ.dbo.employee table with data from ABC\KATMAI.XYZ.dbo.employee using SSIS Package. ABC.CONFIG Table contains connectionstring to those databases, 1 for ABC.XYZ and 1 for ABC\KATMAI.XYZ .
SSIS packages contains: 1 Dataflow Component which inturn contains one Oledb source component and one oledb destination component. Connection Managers : ABC.XYZ , ABC\KATMAI.XYZ, ABC.CONFIG
Now i am using Environment variable "ssisconfig" with values Data source = ABC; Initial catalog = 'XYZ' and remaing thing...
Now when i run the package, ABC.XYZ.dbo.employee is not getting populated. What is the reason??Thanks,