No Rows Transfered

Hello

I have to connect to multiple server to get the various information. I am now passed the hardle of connecting with various server and now the problem I have package with using OLEDB source and running following query

declare @CfgServer table
(cfgName nvarchar(100),
Minimum nvarchar(100),
Maximum nvarchar(100),
Config_Value nvarchar(100),
Run_Value nvarchar(100)
)
Insert Into @CfgServer EXEC sp_configure


select cfgName,Minimum,Maximum,Config_Value,Run_Value,@@Servername svrname from @CfgServer

Since I have to insert servername also beside config info to the table that is why I am using table variable

Now everything runs fine with no errors but there is no rows copied to destination table.

Please help. I already tried with temp table with same results.

Thanks

--

Farhan