Search results for query: *

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

Hello Every one, I am using (SELECT ROW_NUMBER() OVER (PARTITION BY ft.EmpID , dimdt.YEAR_NUMBER, dimdt.MONTH_OF_YEAR_NUMBER ORDER BY dimdt.Date DESC) row_number , field1 .field2 .. ec my ft table has millions of row. I can get the result (month end most recent records of each employee) what...

Hello everyone, I have reporting services project in visual studio. I need to add a same dataset based on same datasource accross all the reports in my project. Is there any way to do this just running one script. It's difficult to open all the reports and add manually. Any solution? Thanks

Hi John, this is actually my question. I mentioned history of salary paid. sometimes increasing and sometime decreasing. Jut like you can plot on chart and get a slope to see visually trend, salary is increasing trend or decreasing, I need to figure out in terms of yes no values .

Hi All, I am not sure is this proper forum to ask. I have multiples solutions for SSRS reports in Visual Studio 2016/17. I am required to modify formatting values (font size and txt color) for all the reports in all the solutions with same value to make it standard. Is there any way I can...

Hi John, sorry for misconception rather my mistake, the 'decreasing flag' has just sample value (the way results should be displayed). I just trying to identify a way which will calculate/determine this flag value. Hope this explanation will help. Thanks