how to import data from excel intro sql db using ssis
Hi, I have a little problem ... How do I create a procedure within a cube so that I import data from an excel file in that cube? I tried OPENROWSET and OPENQUERRY but with no success. OS on which it is SQL Server Win Server 2008 x64 ... Does anyone have any idea how I could do that? Thanks a lot! :)
May 18th, 2011 2:38pm

thanks but i was aiming for coding not clicking in ssis :D
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2011 3:59pm

here's what i've got so far... but this here snippet breaks my string into lines and not columns... :( declare @Delimiter varchar(1) declare @String varchar(8000) declare @idx int declare @slice varchar(8000) select @idx = 1 set @string = 'Mihai, Ion, Popescu, Nicolaescu' Set @delimiter = ',' -- if len(@String)<1 or @String is null return while @idx!= 0 begin set @idx = charindex(@Delimiter,@String) if @idx!=0 set @slice = left(@String,@idx - 1) else set @slice = @String select @slice -- if(len(@slice)>0) -- insert into @temptable(Items) values(@slice) set @String = right(@String,len(@String) - @idx) if len(@String) = 0 break end
May 18th, 2011 4:10pm

tooked me a while to get it done...but it's done :) it's working :) thanks :) can you send me the dstx file also? this is my email adress: bogdan.cazacu@muller.com.ro (or try this on the the 1st fails: cazacu.bogdan@gmail.com.ro) i really wanna compare it to mine to see the differences... thank :) ps: sorry for the delay :D
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2011 6:15pm

I just emailed you a sample good luckSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).
June 20th, 2011 7:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics