Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yokspawn
Starting Member
2 Posts |
 Posted - 2006-05-25 : 17:22:26
|
| Hello,I need to create an excel file from a sqlserver table and then export the said file to an ftp site. I can already create the excel file out of my sqlserver 2000 table. However, I'm not sure how to proceed exporting the file to the ftp site.I'm really new to DTS and have exhausted many hours researching on this. Can anyone direct me to any article or teach me how to do the task?thanks... |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-25 : 21:55:08
|
check out nigel's mindsdoor.net  --------------------keeping it simple... |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-26 : 03:51:32
|
| http://www.nigelrivett.net/FTP/s_ftp_PutFile.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
yokspawn
Starting Member
2 Posts |
Posted - 2006-05-29 : 11:42:03
|
| thanks! that was really helpful...i'll just need to put together everything! again, thanks a lot! |
|
|
|
|
|
|
Export Excel to an FTP site using DTS