Hello Sir, could you please make full tutorials for MSBI?
@pratikphulwade10 ай бұрын
How we can use ~ operator as delimiter?
@JP-td8gt5 жыл бұрын
I think you need text qualifier as ". Some of the names fed over to the address column.
@vinodhkumar30185 жыл бұрын
when I execute package second time data will again loaded into excel ,,so data will be duplicated in excel and size is also increased.. my question is if I execute the package 10 times,, then only excel sheet contain only one set of data,, what are the steps to do to get the result
@b2alearning7285 жыл бұрын
Vinodh, you can ether use script task to remove duplicate records from your excel file or you can restrict duplicate entries by sing script component or else you can replace your prev file with a sample file every time, whenever you run your package using file system task. Also, we will soon have this assignment in our Task 3 video.
@rilbilongsonna22035 жыл бұрын
Where can I get the dummie data from Excel and text files that you are using?
@b2alearning7285 жыл бұрын
Please reply with your email I'd and we shall forward you the sample source files via mail