DSXchange

The second file can only support a reject mode and not an input stream to your second transformer. What exactly are you trying to achieve. From your design and explanation it is clear that you are reading from a sequential file and writing to another which inturn is writing to another. Why do you ne...

Any where. Depends upon your requirement. You can call it in the before/after job subroutine or before/after stage subroutine.

Before job subroutine, 'ExecSh'. Not a stage but a pre-process that can execute command line utilities and programs/commands.

So Craig, you have a 360 huh, you seem more like a, WII person

So your getting the "Invalid Userid and password" error now? That clearly says it all. Make sure your username and password is valid

Search the forums. This has been asked and answered before.
Try the following link
http://www.dsxchange.com/viewtopic.php? ... +has+grown

Search the forums. This has been covered extensively before.

I finally got a chance to write a small bat script to do this for you. Here ya go. @echo off REM Set variables set last="" set fileToParse=%1 set tmpFile=%2 for /f "tokens=1-4 delims=/.- " %%A in ('date /t') do (set Dow=%%A&set mm=%%B&set dd=%%C&set YYYY=%...

Try a search. This has been covered before.

I dont think there is an easy solution. You cannot concatenate null to another string and expect to get the other string. It will always give you null. You will have to change your jobs. The other easy way that I can see is to update your source to a space whereever a null is present. But even for t...

ArndW posted a method to get rid of these orphaned datasets by analyzing their magic number. He has posted commands to do so. Search for it.

Use the above for alphabet column. This will give you A-, B+ etc.



Use the above for numeric field. This will give you only numbers.

Ok now your confusing me, I thought that you wanted to capture other characters like (-) and (+) etc. Isnt that the case? Once again, for only extracting numerics use DIGITS(in.Col) OR OCONV(in.Col, "MCN") for only alphabets use LETTERS(in.Col) OR OCONV(in.Col, ...

Well, is your target column set as nullable or not nullable? Make it the same as the field your fetching from the lookup. You might not need the modify stage as this is a new column that your fetching. If you were changing an existing non-nullable column to nullable then, I believe, you will have to...

Then your target should be defined as either decimal(5,2) or decimal(19,4), depending upon what table your searching.