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“反恐精英”吗？似乎见过你的签名档，哈哈
|
