dear kodali ranganadh there is no support of dts in sql2005, and i donot know ssis, can you guide me step by step, or can you suggest me any site which teached ssis
thanks and regds annadurai On 3/20/09, kodali ranganadh <ranganadhkod...@gmail.com> wrote: > > 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 <paa...@gmail.com> wrote: > >> >> I think it is the best solution to import data from excel to sql >> server. >> >> On Mar 19, 1:57 pm, anna durai <downtown...@gmail.com> 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 <tush.gu...@gmail.com> >> 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 - >> > > -- ANNADHURAI DOWNTOWN EXPRESS / CHENNAI LOCAL COURIER SERVICE 98400 51690
