i dont have it in my sql library .. is there any other way using traditional sql?

i want to write a tsql query for it.

is there any alternative of linked server? we no longer support linked server..everything is being done by SSIS packages

Ok.. so is it need to be installed on server? if i dont have access to server, i can't connect SQL server and Oracle?

actually i have a "send email" utility which picks every sheet data which is named after every student...so i was trying to create as many worksheets as there are students...

Make sense... to check where it's using more space... i commented few of the parts of original job and executed on my local desktop matching.. it ran fine until it...

Error is: COuldn't allocate space for object 'XYZ: temporary run storage' in databas tempdb because the primary filegroup is full. Create disk space by creating unneeded files. SQLState 42000(error1105)

sorry for confusion. 4/14 mean either 4 months or 14 months.

For two tables, data is less in one table from other table but size (data space+index space) is higher then the other table. What could be the reason?

Thank You. and for Table size, Right Click-> Properties -> Storage-> Index Space+Data Space will give the size of the table.. right?

I have few questions based on wht you mentioned:

1) Is SSAS server same as SQL Server

2) My pivot tables has around millions of data.

3) Currently many pivot tables and charts...

On control task flow where i was creating table, i added drop table if already exist. Also Right clicked on Destination and clicked on Properties and made “validateExternalMetadata” as False....

Problem is resolved.

I build a solution is SSIS data tools. I build control flow and data flow. when i click on individual tasks in control flow (right click and execute) then package...