let me refrase it.....

when i am loading multiple files if the sheetname is not constant then the package fails.

is there a way to set that dynamically.

thanks

But then it would fail if the file format is not correct.

say i loop around four files and one of the files have not got the correct column names, it...

umm i will try this but i thought there might be something like setting it to success in script, as we do for component : Dts.TaskResult = Dts.Results.Success

^^ this is the error

Error: The result of the expression "@[User::Filename]" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the...

thanks that sorted it

i have tried the insert statmenet .... but doesnt insert anything.

here is the code

insert into table3(ID, name,Phone, MPhone)

Select table1.ID, table2.name,table1.Phone, table1.MPhone

FROM table2...

thanks isn't there any way to do it using the ssis components

Cool thanks for all your help.

one more question(sorry to be a pain):

how would I insert columns from two tables into one table??

say i have one table called table1 which has...

Thank you guys I managed to get the sheets. but now i have another problem.

one of the sheets has constant name say 'Sheet1' the other one will change depending on...

anyone on this????

let me clarify a bit more,

i want to load data to sql server database. the excel sheet comes with password, i have the password i am just lost...

yes i was trying that. but anyway i had to create another data flow task inorder to do it

thanks

TRIM(SUBSTRING(isnull([Column 0],''),35,3)) + "-" + TRIM(SUBSTRING(isnull([Column 0],''),38,3))

thanks.

there were some errors and i corrected them(mainly path problems). but now it says failed to connect. connection refused.

i am doing a connection using this line:

psftp username@hostname -v -bv...

how would i ran the batch from command line(i mean the command)

hi,

i have created a batch file which downloads files from sftp. it runs fine on my pc but when i copied them to the server, they dont run.

simply a dos...