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 |
|
sanjnep
Posting Yak Master
191 Posts |
 Posted - 2006-07-25 : 10:55:54
|
| Hi All,I want to update value of [Source Filepath]from "\\scidss02\Apps\SSSReconcile\ClientFiles\" to "\\scidss02\Apps\IVRReconcile\ClientFiles" on INI files after running DTS package 1st time.So next time when I run DTS package the value should be "\\scidss02\Apps\IVRReconcile\ClientFiles".Do you have any idea how can I do that?My INI file is like this___________________________________________________[Source Filepath]value=\\scipisi25\Apps\PRAReconcile\ClientFiles[Destination Server]value=VCRP8DH1[Destination Database]value=Q_PRASDB9[Destination Table]value=ReconcsU_______________________________________________________Thanks Sanjeev Cleveland OH |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-07-25 : 11:45:02
|
Any idea friends?Thanks  |
 |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-07-25 : 13:20:03
|
| Sanjeev Shrestha12/17/1963 |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-25 : 19:27:10
|
why don't you write a VB / J script to do this and have DTS call that script.
KH |
|
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-07-26 : 09:32:32
|
| How to do that with J script or VB script?Thanks |
|
|
|
|
|
|
INI file update to run DTS package