but I don't know the filename or you can say any fillename in directory.

I know only path upto directory.

if a file is in directory then execute second step.

please...

thanks , this wht i needed

use script task to copy latest 12 files to a folder & use for loop to import data

enter data in sql tables and then take out for different destination

flat files ---> sql server tables---> different files.

for first time it is working and next time it is not

here wht i did

1. created variable and it value is filepath - c:\test\qa.xls

2. given this variable in excel connection...

thanks for reply.

but i don't know filename eachtime.

meaning how to get filename and pass it as a source for dataflowtask.

refer this

http://bi-polar23.blogspot.com/2007/09/loading-multiple-excel-files-with-ssis.html

and let me know

do it through dtswizard and then save this package.

goto start --> run--> type dtswizard --- > select source ---> select destination --- > do as per gui ---> in...

- no , i can't use any thirdparty tools due to security issue.

- yes I have 4 types of extension files in a folder (.vv ,.hh,.pp,.ss)

- .vv extension should go...

create the data flow task using import\export wizard.

goto start --- > run ---> type dtswizard ---> select source as flat file ---> and go on ---> in the...

but how .ks file will go in KS table?

send me dts package that you develop on my input,

i will give it to my friends..........

DTS Package for Reporting Low Disk Space

This VBscript code will check for low disk space on the local SQL Server. Schedule the package to run once a day, and let...

ok, can you tell me how to check if file exists , then rename and move in step using same link?

hi

it is better if you would develop package and give it to me.

here are the steps

1.) you will get any excel file in a directory

2.) you have to import...