DSXchange

Thanks,

1) He has to put an entry in /etc/hosts for HT2 in my test server.

will let him know.

2)can 2 ftp stages used in one job?
there is space in the name of the file is that a matter?
i.e

Actually I did not ask him to put an IP entry for HT2 but still its working as I replaced the IP address in place of server name in the path. If the admin does that can I give the server name in the path? another issue which I am facing now is there are two ftp stages in my job. one is working and t...

yes,
used the command on test machine

ftp HT2

it says unknown host, but when I give the IP address it asks me for login name and password.


so do I need to use IP address in the path of the FTP stage in place of HT2.

please let me know!!

@ray,

how can I test the machine?

please let me know?

Thanks, So you mean to say do manual FTP from the remote server to test server? It is working on Development server with the same information,Is there anything to do on the test server. ftp://HT2:21/user_information.psv when I copy this url on in the explorer a prompt came and adked username and pas...

Designed a job using FTP stage to read the files from a remote server. It worked properly i.e read all the records and loaded in the DB on Development server Now I imported the same job to another Information server i.e (development to test),In this test environment the job aborts with an error FTP_...

Thanks, So in the sequence we need to use an other job which has datasets and table. earlier I never user dataset,Is it something to store the data and then read when ever needed? one more doubt which I have is while doing look up between the source and table1 what will the keys be....I assume the k...

designed a job to load data into a table which has 6 fields user_id,app_id,sch_id.....these 3 together form primary key and other three are join_date,rene_date,end_dt first time when the job runs around 5000 records are loaded in the table. and the end_dt has to be null for the first load. the job i...

Information services connection error In the console where we select the information service connections to work with,when I test the connection I get a popup which says validation failed. validation error:- connection refused to host:273.27.300.347:nested exception is jane.net.connection.exception....

yes used the same code and changed the datatype to date in the output of the transformer.

now the field look like the null fields have nulls in them and the rest of them have 1/1/4713.

is it because the datatype has changed or is this the default value given in the string to date() convertion

So..is it something like below manner

tranformer input-----renewaldate,varchar,yes

column derivation-------- transformer output--renewaldate,date,yes

doesnot accept nulls is for other field(acceptdate) which is also date but NOT NULL and the default date is given to that field. this field(renewaldate) can accept nulls as it is date NULL As you said If I do not use stringToDate() conversion function at all than If the dates come in this field rene...

try using the two functions seperately in two transformers....

one for date to string and other for string to date

transformerinput-----renewaldate,varchar,yes
columnderivation----- tranformeroutput-------renewaldate,Date,yes

thats the syntax chulett,

thanks

Exact presentation of the null dates column is 1)renewal date is the column which I am reading from a file and the datatype is varchar 2)the renewal date was null for all the records and looked like " " in the file. 3)removed the quotes by using field(dslink102.renewaldate,'"',2) whic...