what's your requirement? how many files do you have? is this a one time thing or going to be a regular process? in SSIS you can use a vb script to get the file names for dynamic file name process.
【在 p********a 的大作中提到】 : one file by one file?
p*a
7 楼
just want to process all the files by batch automatically. VB script sounds too much for beginners like me. What about "OPENDATASOURCE"?
p*a
8 楼
你是ID“反恐精英”吗?似乎见过你的签名档,哈哈
S*0
9 楼
that would be a simple script, use the FILESYSTEM object to get the file, rename it, them load the data. SSIS is my take too.
sounds
【在 p********a 的大作中提到】 : just want to process all the files by batch automatically. VB script sounds : too much for beginners like me. What about "OPENDATASOURCE"?
p*a
10 楼
thanks!
j*n
11 楼
check out FOREACH LOOP task, even no vb script is needed...
【在 S*****0 的大作中提到】 : that would be a simple script, use the FILESYSTEM object to get the file, : rename it, them load the data. : SSIS is my take too. : : sounds
i*a
12 楼
oh, it pick up the files without specifing names? that's easy then.
【在 j*****n 的大作中提到】 : check out FOREACH LOOP task, even no vb script is needed...