How to remove stage data through Sequential file stage
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
How to remove stage data through Sequential file stage
Hi,
I am extracting a table and then loading it into another with a sequential stage in between.
i want to use the filter option in the sequential stage to delete this file once my load in over. Any suggestions?
Any other way i can delete the file? other than a after job routine?
I am extracting a table and then loading it into another with a sequential stage in between.
i want to use the filter option in the sequential stage to delete this file once my load in over. Any suggestions?
Any other way i can delete the file? other than a after job routine?
You can use an IPC stage instead of a Sequential File stage, if you are doing the whole process of extracting and staging in sequential file and then loading into another table in a single Job. Else, another way I could think of would be to use a Execute Command stage in Job sequence after the Job, but using an after job subroutine would be much simpler and easier. May I ask why you would want to avoid using an after Job subroutine?
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
In the next job, you can do it in the before job subroutine.
Also, i would advise not to delete the file untill the end of the entire process. You might be needing to look at the file if something goes wrong. Basically for debugging purposes. If that is not an issue, then i would go with Kris's suggestion. Use an ipc stage.
Also, i would advise not to delete the file untill the end of the entire process. You might be needing to look at the file if something goes wrong. Basically for debugging purposes. If that is not an issue, then i would go with Kris's suggestion. Use an ipc stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Yes, you can write to sequential file which is present on another shared drive which is mapped to your ascential server. You will have to use UNC(Universal Naming Convention) path as the path for the sequential file.
why would you want to hijack a thread? It is not adviced.
HTH
why would you want to hijack a thread? It is not adviced.
HTH
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
It doesn't have to be visible to be able to write to or read from. If the shared drive you wanted to write data to is mapped to the Ascential drive then that should be enough. You can just specify the UNC path of the mapped drive and sequential file stage is going to write to or read from that drive.DSguru2B wrote: Try browsing for the file server from within the sequential file stage. If the server is visible, then you can.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
You should give the filepath as
Code: Select all
\\servername\foldername\filename.csv
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson