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