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 |
|
ciaran
Starting Member
40 Posts |
 Posted - 2005-11-11 : 05:58:11
|
| Hi, I have to read a text file from a SP. I have never done this so what would be the best way of doing this.I am aware that dts would be ideal for this but i cannot touch a production dts package. I was also thinking that i can call the another dts package immediately after the production one and therefore i will not interfer with he main load DTS package. What you think. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-11 : 06:16:47
|
| In Books On Line, SQL Server help file look for sp_addserver and read the topicUse the Microsoft OLE DB Provider for Jet to access a text fileMadhivananFailing to plan is Planning to fail |
 |
|
|
ciaran
Starting Member
40 Posts |
Posted - 2005-11-11 : 06:38:57
|
| Thanks for the reply Madhivanan. Through my ignorance i fail to see how sp_addserver will help me read a text file from an SP. Am i missing some thing. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-11 : 06:47:07
|
| Read the topic I specified fullyMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Read a text file from a SP