How can we put another format data into sql server 2005

• jagpalsingh4

  Ten Centuries

  Points: 1311

  More actions

  March 19, 2008 at 10:49 am

  #120473

  Hi,

  How can we put excel or anyother format data into my database .

  like in oracle we use sql loader .but plz tell me in sql server 2005 how can we do this .. i just try to do with BI thorugh ssis but i cant

  bcause there is no option for 'data tranformation project '.so plz teach me that how can i do this .....

  Thaxxx

  jagpal singh

• Mohan Kumar

  SSCertifiable

  Points: 5365

  More actions

  March 19, 2008 at 12:44 pm

  #791659

  You can use import wizard to do this that is available under TASKS property of Database.

  [font="Verdana"]--www.sqlvillage.com[/size][/font]