DSXchange

I was trying to load data into DB2 Database using ODBC connector. I an new to this work i.e loading data and In the place of data source I used the name of the database But for some reason the job fails and The error is Data source name not found and no default driver specified What could be the pro...

That worked!!

Thank you

The source is a file coming to the server which has a field Name-UserID this field should be divided as two separate fields as Name and UserID The input is one field Tom-101 Joseph-102 John-103 the output has to be like two fields separately divided Tom 101 Joseph 102 John 103 please suggest me the ...

I am using ODBC connector to insert records into a table. I read the data from two flat files each one has around 7 to 10 variables. I need to insert 5 from one flat file and 6 from the other flat file. These two files have a common varible. which stage is better to use before loading into the table...

Great!!

That worked, Thanks Ray

Now my job is in this way

FTP------------->transformer--------------->sequential file

I used the option first line is column name as true but still I get the column names in the records.

How can I skip the first row in a transformer?

please suggest me

thanks ray Got a solution The admin gave me another hostname for the same server which is FTP so now I can read everything and write it to a file but the problem is the FTP stage has no option which says first line is column name true/false. Now the column name is also read as a row,please suggest m...

I am using 8.0.1,searching tells 8.1 has the feature but not 8.0.1

If this doesnot support SFTP then the server has to be enabled as FTP instead of SFTP.

Is this the solution or any other solution please let me know

Thank you

I received a automated message from the server which has the same port number along with the host name,userid,password

The remote server has SFTP service enabled on it,does FTP enterprise support server with SFTP service.

I used the path in uri of ftp enterprise as ftp://dxter.coc-eft.org:22/applicationid.csv and gave everything username,password, transfer mode in the columns tab I entered the metadata also.....but I got the same error... FTP_Enterprise_1: uri : ftp://dxter.coc-eft.org:22/applicationid.csv is not val...

Thanks
In the properties tab the URI do I need to give the path for that file?

and I tried to import the metadata through sequential file definitions but cannot view the files to import Is there any change in the definitions from import

In the place of URI do I need to give the path of that specific file in FTP enterprise stage?
and in the columns do I need to manually enter the names of columns?

and I used the transfer protocol as SFTP but this is not asking me any password is that OK.


please let me know

sure I will make sure with my admin department. thanks

Coming to the format of the file the top row contains the names of the columns does the FTP stage reads the file in the same manner i.e take the first row as the column names and the rest of the records as data.

Thank you franklin So I will use the enterprise stage which allows me to read the data from the file. In that stage properties URI ---is this the path of the file? Ftp command---what is this? username,password is the access to the server and the transfer type is ASCII. please verify my doubts in tha...

thanks, so the FTP stage(enterprise or plug in) can be used directly to get read the data and transform the data and then load it. something like FTP--->transformer------->DB which one do I need to use? Do I need to talk to the environment support about the permissions to that server? or something e...