Thanks for quick response.

It has cleared many doubts.

well,i don't have admin rights but now,i know in which direction to proceed..

thanks

Hey Mike,

So, does it mean Authentication mode in SSIS is different than in SSAS.

Because, In SSIS..we can use SQL server Authentication. But is the same not true for SSAS?

Thanks

What are you trying to do?

XML to SQL?

are u using SSIS for same?

u can use a data flow task and there take XML source, configure it to give XML file...

Its possible..

do u have XML file?

with SSIS, you can let SSIS generate schema or as in ur case, u can provide the location of xsd.

Just guessing..

u can use for each loop,

provide the container with server name and location thru a variable...

and then, ETL can be performed.

AS i see here, the tricky part is...

I think you are correct. Its empty values causing the problem. Using conditional split, I was able to get only those rows where data contains numbers i.e. numeric values. I...

provide more info.

how are u trying to do it etc..

Ok, thanks.

I will try that.

have u tried creating ssis package for same?

I think you achieve your desired output.

Thanks for your inputs.

yeah, Provide some more information.

A possible reason for error could me syntax error while trying to execute it.

with this, it should run...

declare @r int

execute procname '1','2','3',@r output

select @r

thanks

how about frequency of transactions?

Are these insertions taking place very frequently?

Any connection restrictions in there?

in your case, how abt connection between publisher and subscriber?

create proc procname

@subject1 int,

@subject2 int,

@subject3 int,

@result int output

as

set @result = @subject1+@subject2+@subject3

Is this want you want?

I think this sproc will allow you to enter values for three subjects and then...