DSXchange

Note that there are no null fields in a sequential file, only empty ones and they are not the same thing. The property mentioned will allow you to define the "in-band null" value for that field, what incoming value should be transformed to a null during import.

That is the long established "mathematical way".

Elapsed time is the total time for job , I would like to calculate time taken for particular link Unless you have a job with a process break then each link runs for the duration of the job. Regardless, someone smarter than me would have to say if there was any place that link start/stop times are r...

What wouldn't be "appropriate" about it?

If you are going to make statements like that, please also take the time to explain them.

No clue but if you suspect the issue lies with the Fold function, seems to me you could replace it with substring rather easily.

I don't believe that is possible but we'll see what other people have to say. Perhaps someone has been in this same situation but I don't recall anyone posting this before. Regardless, IMHO this is something that you should be putting before your official support provider.

So... what exactly did you try? What happened when you tried it?

... or a looping Sequence job.

What?

So... you've put a list of filenames in a file and want to know how to leverage that file? If that's the case, then use File Pattern in the Sequential File stage and give it your filename.

How have you defined the record? As noted, try setting it to one large varchar so the entire record transfers over as a string rather than individual fields, see if that fixes it for you.

No there isn't, not explicitly. You'll need to get the LINKROWCOUNT and the elapsed time for the run and do some maths. Use DSGetJobInfo() for the latter.

Yikes! Don't let any of the security guys hear you mention "handy SQL injection tool".

Forgiving in job, yes, but still enforce everything at the target.

S. BASU no pass, S. BASU want pass like cppwiz.

As noted, if you are looking for a substring inside a string, then use the Index() function.