I am usin Microsoft sql server 2008 , I tried all the 3 solutions , but every time I get the same error
"Error at Data Flow Task[OLEDB source]:No colum information was returned by the sql command"
I am using the follwoing batch of sql statments to retreive the server level configuaration of all servers in my company. The table variable @tb1_SvrStng has 83 columns and it is populated using diffrenet resources.
So I summarize the sql script. I cannot use it as stored procedure because this script is going to run against 14 servers(once for each server)
So if i store the procedure on one server , other server canot able to execute that procedure in its context.
Please help me to solve my problem. I will highly appretiate your help.
I am not using any temporary tabel in my script.
declare @tb1_SvrStng table
insert into @tb1_SvrStng
srvProp_CNPNB , ........
select convert(varchar, serverproperty('BuildClrVer')),
declare @temp_msver1 table
id int, name varchar(100),
insert into @temp_msver1 exec xp_msver
set xpmsver_ProdVer =
select value from @temp_msver1 where name = 'ProductVersion'
select value from @temp_msver1 where name = 'Platform'
srvProp_SerName as srvProp_SerName,
getdate() as reportDateTime,
srvProp_BldClrVer as srvProp_BldClrVer,
srvProp_Collation as srvProp_Collation,