Hey Thanks Guys,

I was in confusion that whether i can combine it or not.as you said better to use Temp table,how can i use it in my case

Thanks

will try to do that.thanks for suggestion

we use to run these queries and prepare a excel report for the users.but now we need to combine this queries, i mean to say that they just want to...

When i changed in advance editor of Source i m getting error as [OLE DB Source [1]] Error: The "output column "id" (6493)" failed because truncation occurred, and the truncation...

I tried to use this expression.i have other question.in my source table policy number column is nvarchar(80) and in my destination table that is varchar(6),what i need to use here.it...

i have somany records in this table.do i need to manually change all.how can use this expression in deriverd column

Souce formate is 2010-07-01 00:00:00.000 and destination formate is 20080701

Hi,

I am trying to use xml source and in connection manager window,its asking me for the .xsd file location.i dont exactly know what it means.if i select inline to disable...

Thanks for the responce,can u pls tell me2 or 3 examples .this is the question im facing in all interviews.