DSXchange

Tks for your reply. need a clarification, the same import of the job was success in the another project. in one particular project it was not success and display the error as I stated in my post. pls clarify me. tks.

You can write stored procedure to delete the 22 tables.

pass the filename, path as parameter, read the file and store the value of the content in variables and then while calling the stored procedure pass on the variables value as parameters to the procedures.

I am using a sequential file stage to view the sequential file. I have the following properties set: -------------------------------------------------------------------------------------- TRY1: ----- Record Level: Final delimiter = none Record delimiter string = \r\n Field Defaults: Delimiter = tab...

ArndW wrote:Unless you have run out of disk space, the most likely cause is that your userid doesn't have OS level privileges to create files in that directory. ...

tks a lot, will try and pass on comments.........

Error while creating job Error on CREATE.FILE command (Creating file "RT_CONFIG13133" as Type 30 cannot create file RT_CONFIG13133 Unable to create operating system file "RT_CONFIG13133" Processing cannot continue. able to import in one project and not able to do it another prjec...

You can use this following in the derivation side oconv(iconv(DSLink2.a,"MTS")- iconv(DSLink2.b,"MTS"),"MTS") for example, A-11:20:30 and B-11:20:20 then C will be 00:00:10 you can has the target as sequential file. It can be stored as timestamp. try this and pass on yo...