Viewing 7 posts - 1 through 7 (of 7 total)
Thanks for the response
If its a straight move to two tables i can do wht u mentioned.
But the data into table2 need to be split for various cities and states...
March 31, 2013 at 6:43 pm
tq...but if u hav a chance, can u help me out wth a sample query...
February 7, 2012 at 10:01 am
create table tbl_indicator
(
grp_nbr varchar(30),
sect_nbr varchar(30),
indicat varchar(30)
)
insert into tbl_indicator select '001234','100','p'
insert into tbl_indicator select '002345','101','s' ...
February 2, 2012 at 11:17 am
ayemya (12/6/2011)
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::SourcePath]+ @[User::FileName] +";Extended Properties=\"Excel 8.0;HDR=YES\";"The excel connection string is overwritten. The above script is set in expressions.
ya but whn am configuring my excel source and...
December 6, 2011 at 2:12 pm
mya (9/25/2008)
Look at this package. All you need to do is change your database connection,variables and its expression.
1. change connection to your database
2. change variables values : SourcePath,Dstpath and...
December 6, 2011 at 12:48 pm
how could be the name of excel file is "c:\jenny\" in excel connection manager??? it should be something with the extension ".xls"???
December 6, 2011 at 12:47 pm
Viewing 7 posts - 1 through 7 (of 7 total)