DSXchange

Hello Everyone,

I was just wondering if it was possible to read a specific record from a sequential file source stage. I know there is a filter clause which can help me eliminate headers, footers and so on but I was wondering if it would be possible to extract say JUST the nth row of a file.

Thanks!

Thanks for your replies. Yes, I know that option to select multiple jobs exists. Just as you pointed out, we can select the jobs , right click and the drop down gives you a "move to" option which lets you choose the target folder intended for your move. But the thing is , the drop down to ...

Hi All, I am tryin to select and move multiple jobs at once between folders via Manager. But when I highlight the jobs, and I try to drag and drop the selection, it DOES not let me do so. I know there is an option to do it, but i cant seem to figure why its not working the way it should. Also, when ...

Hello, I had a question regarding the type of file attachment you could email out with the Notification activity. I have created a .dat file which is very small in size, but DS does NOT include the file as an attachment and throws a message sayin "WARNING - MISSING ATTACHMENT: Cannot open attac...

Thanks a lot, worked great!

Hello, I was trying to save an existing job sequence to another name, when DS refused to let me do so saying another sequence already existed with the same name. I tried looking under the different categories in the the project for the sequencer which already existed,but could not locate it. Is ther...

Check your unique key constraints in your destination table.

Check your unique key constraints in your destination table.

chulett wrote:It would be a "user written" routine, so you'll need to find it in the Manager and double-click on it to reveal its secrets. ...

Thanks Craig, yep that was easy enough. I appreciate your time.

Hi All, I was wondering if any of you have seen this particulare function in a transformer.I am trying to understand specifically, the meaning of DateTimeCompare(lnk1.timestamp,lnk2.timestamp)='INCLUDE'. This is used as a constraint in the transformer, in the sense that if this condition is satisfie...

The default behaviour of Trim() is to remove leading, trailing and redundant consecutive trimmable characters. Therefore Trim(" ") would leave a single space character as the result. ... Thanks a lot to both of you for your response. Basically , to restate my exact requirement, i need to ...

What happens when you trim('') as opposed to trim (' '), that is trim of a field without a space, and trim of a field with just a single space . I believe trim removes trailing and leading spaces, but what if i want to have just a single space intact? Will trimming remove the single space as well?

Hi , I had a question regarding the ideal partitioning strategy for sorting data , and landing it in 2 datasets thereafter. My design is as : (Inputdata)-->Sort stage ---> Copy ----dataset1 ------------------------------------| -----------------------------------dataset2 That is to say , sort data a...

Thanks for the response. I dont have the previlige of premium membership, but the little that i could see (using stage variables ) tipped me in the right direction :). I stuck a dummy count column in front of brand and code which would take the same value (say 1) ,as long as brand and code didnt cha...

Hi , I have a requirement to perform the following transformation , but im not sure how i could go about it. Ive been trying to play around with it, but my efforts have led to dead ends :(. Brand---- code---------- Position A------ 1 ----------------- X A------ 1 ----------------- Y A------ 1 ------...