Forum Discussion

mauryavijai's avatar
mauryavijai
Frequent Visitor
5 years ago

Need to Connect FTP location as data source in Dataflow BI Servie

Hi All,

I want excel/CSV file availableat FTP folder should be connected in a dataflow.  then using that file will do the  ETL activity to do the following: as example

making the first row headers,
delimiting the double commas then single commas,
then removing total row. 

Any help is highly approciated. 

Thanks,
Vijai
Dataflow

2 Replies

  • mauryavijai's avatar
    mauryavijai
    Frequent Visitor
    5 years ago

    Thanks Fowmy  for your quick response. I will check and confirm. and let you know if any further help required. 

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    mauryavijai 

    Basically, you need to choose the Add Tables in your Data flow and select Folder as the data source then provide connection information  

    Folder Path with the IP: \\11.111.111.111\folder\subfolder
    Gateway and Authentication.

    Once you connect, you can do the transformations