p********a 发帖数: 5352 | |
p********a 发帖数: 5352 | |
i****a 发帖数: 36252 | 3 SSIS or import/export wizard
【在 p********a 的大作中提到】 : 用SQL。有没有简便的方法?谢谢
|
p********a 发帖数: 5352 | 4 one file by one file?
【在 i****a 的大作中提到】 : SSIS or import/export wizard
|
i****a 发帖数: 36252 | 5 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 发帖数: 5352 | 6 just want to process all the files by batch automatically. VB script sounds
too much for beginners like me. What about "OPENDATASOURCE"? |
p********a 发帖数: 5352 | 7 你是ID“反恐精英”吗?似乎见过你的签名档,哈哈 |
S*****0 发帖数: 538 | 8 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 发帖数: 5352 | |
j*****n 发帖数: 1781 | 10 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 发帖数: 36252 | 11 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...
|
i****a 发帖数: 36252 | 12 施主你說的人已經不在未名空間了,
小僧法號馬甲, 捐一些香油錢吧, 阿彌陀佛
【在 p********a 的大作中提到】 : 你是ID“反恐精英”吗?似乎见过你的签名档,哈哈
|