Through a datastage job we need to load from a SQL Server table to a delimited text file and place the text file in a particular FTP location.
Please suggest how this can be done?
FTP through Datastage
Moderators: chulett, rschirm, roy
If this 'particular FTP location' is somewhere on the DataStage server, then you can handle that with proper pathing in the output stage. Otherwise, you'll need to create it somewhere and then transfer it in some sort of 'after job' activity, which could be a script that leverages FTP or scp or some other transport mechanism.
Or you could use the FTP stage as the target in your job and 'deliver' the file directly to the target server.
Or you could use the FTP stage as the target in your job and 'deliver' the file directly to the target server.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers