Recent content by BTrees

Hi I am trying to connect with Lists data on Sharepoint online. I am working in SSIS-Visual Studio 2017 and using Odata datasource connector. I have installed SDK-2013 as well and followed all the instruction on blogs on this topic. But I am getting error , TITLE: OData Connection Manager...

Hi All, I am a new person in the concepts of Encryption. I have studies few Encryption types and how to configure on a SQL instance. I have been working to design a conceptual model to Implement Encryption in Data Warehousing (ETL) I have the following model like Extract data from...

Hi I have SSRS project in Visual Studion (2017) I want to deploy all same reports in a project to multiple folders on my report server portal (say 6 folders in Total URL is the same). In Project configuration, I can only provide one value for TargetReportFolder, TargetDatasetFolder, and...

I am processing/upload a simple csv file with few columns. In each column I have simple text data with no more 50 characters. but SSIS Lookup Component Error -"Row yielded no match during lookup" for one simple column It is confirmed that data correct and no issue with matching values. When I...

Thank you very much Frederico for the solution. I got Ideas , so far the following works for me $arrResult = @() $columns = "ColA","ColB","ColC","ColD" $dif_file_path = "C:\Users\$env:username\desktop\f1.csv" $dif_file = Import-Csv -Path $dif_file_path -Delimiter "," |select $columns $columns...

Hell Everyone I am very new in powershell. I have a requirement to code some tests in Powershell. I am trying to validate a CSV file by finding out if there is any text value in my numeric fields. This is my source data like this ColA, ColB , ColC , ColD, 23 , 23 , ff ...

Thank you Mikrom, it looks very help full I am trying this.

Thanks Mikrom, regarding your validation script, is there something that you can share please

Hi All, I have a requirement of validating CSV file before loading into staged-folder, and later have to load into sql table. I need to validate metadata (the structure of the file must be same as target sql table) No. of columns should be equal to the target sql table order of columns should...

Thanks you Frederico. I tried it according to my folders and it worked like a charm.

Thanks Frederico for the response. I think I have provided all the information required in terms of folders and file structure. My requirement is to move multiple files from the mentioned source folder to multiple target folder based on their names. e.g files starting with 'Customer' should to...

Hi All, In SSIS or SQL-stored procedure, I need to load multiple files to multiple folders with respect to file names I have a scenario Source folder = “Data Source Folder” Files in source folders Customer_datafile_data.csv Customer_Branch_data.csv Customer_City_data.csv...

Hi All, In my SSRS report, I am using following code in a field's expression (ACTION>URL)to call another PowerBI report based on the field value ="https://PBIReportservers.ca/Reports/powerbi/Myfoldername/Myreport?filter=mydatasetinpowerBI/datasetfield eq " & "'" &Fields!Myfield.Value & "'"...

Hi Fred, I have sent you the information. Hope the address would be ok. Thanks

Thanks fred. Due to privacy policy , I can not share original code publicly. Is there any way to share privately? Thanks