yes ..DTS/SSIS are the ultimate solutions for doing these kind of Data Trsnformation.
for simple kind of operations like tranfer bliendly from Excel to SQL Server, you can use IMPORT/EXPORT wizard if do you need large data transformations in the middle of data moving for most best solution is SSIS. regards ranganadh kodali On Thu, Mar 19, 2009 at 10:56 PM, PaaPee <[email protected]> wrote: > > I think it is the best solution to import data from excel to sql > server. > > On Mar 19, 1:57 pm, anna durai <[email protected]> wrote: > > thank u tushar, i will try it out and come back to you > > > > thanks and regds > > annadurai > > > > > > > > > > > > On Wed, Mar 18, 2009 at 2:34 PM, Tushar Gurav <[email protected]> > wrote: > > > Hi aadi , > > > > > plz try this out . > > > > > What will be the result good or bad > > > > > plz forword it me too > > > > >http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx > > > > > Thanking you. > > > > > -- > > > Tushar > > > > -- > > ANNADHURAI > > DOWNTOWN EXPRESS / CHENNAI LOCAL COURIER SERVICE > > 98400 51690- Hide quoted text - > > > > - Show quoted text - >
