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

[mauryavijai]

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

[mauryavijai]

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

[Fowmy]

@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