I Know this sounts a bit wierd but it works fine on another PC with the same version. Is there any thing else that i can do. Please help.

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790:...

Not Very sure how do i find it out ?

The easiest way to do this is using the SS 2005 Import export wizard. Just log in to sql server 2005 management studio right click on the source database...

Thanks Peter,

It is working, however i have also found another solution plz let me know if i...

yup, however can i do it throut ssis and shedule it ???

Hey guys you know what its working Thanks a lot, however i was wondering if i could schedule it.

I have SELECTED OLE DB SOURCE OPTIONS FROM DATAFLOW SOURCES,

pivot option from data flow transformations and excel destination option for data flow destination.

I have linked these...

This is the error that i am getting

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Data Flow Task [Pivot [16]]: No Pivot Key found. One input column must be used...

Hi Jef/Jim,

Thanks for your early help, however i think that i am not very clear while asking the question. All i need to do...

yes it exceeds the no of cells

Hi

I am facing the same problem somebody please help