Recent content by aoshi_kh

  1. A

    error on deleting file in ftp

    I was using SharpSsh for sftp in my vb coding, it was working good for upload and download file. But when I trying to delete file from sftp server with below code, it keep hit error of Invalid URI error. Anyone know how should I fix this? Dim ftpRequest As FtpWebRequest =...
  2. A

    Question perform bulk insert

    totally no idea how to assign the source no to variable. while is ok.. will get help from other beginner forum that can guide already. Thanks
  3. A

    Question perform bulk insert

    hi sir, i did store all into the csvdata column. but i dont know how to the source no into variable from that?
  4. A

    Question perform bulk insert

    I was now able to populate the data into data table, but may I know how to compare the source_no on this? Using csvReader As New TextFieldParser(C:\Test\ & xLoad01) Dim csvData As New DataTable() csvReader.SetDelimiters(New String() {":"})...
  5. A

    Question perform bulk insert

    thanks for you advice, while i still new to this.. can you explain more how it work for my situation below? appreacite your help. 1. need to check each line it's same source no? each text file can contain only 1 source no, so I need to compare within the same text file, if have difference...
  6. A

    Question perform bulk insert

    Hi, currently I have text file showing as this Class_ID, USER_ID, SOURCE_NO 10001:A01:AAA01 10002:A02:AAA01 10003:A03:AAA01 10004:A04:AAA01 10005:A05:AAA02 <-- this is wrong, I need to compare within text file as well. Did anyone know how to bulk insert the data I read from text file? it many...
Top Bottom