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...

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 ...

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...

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 & "'"...

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 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 All, I have data like EmpID Salary Paid Date Salary Paid 100 627.8 1/11/2019 100 1085.56 1/25/2019 100 1055.01 2/8/2019 100 980.6 2/22/2019 100 653.35 3/8/2019 100 870.94 3/22/2019 100 385.2 4/18/2019 101 2032 1/4/2019 101 3466...

Hello Everyone, I have a scenario where I will have to load my table incrementally using a sql query. CDC not an option and no primary key in both source query and target table. Previously I was doing truncate table and simply reload using stored procedure. I want to reduce time and resources...

Hello Everyone, I have a local server A and linked Servers link-1, link-2 , link-2 (could be many) I have one procedure call Proc-1 on local server A. Which runs and fetch data from databases into a local table called Table-1. I need to run this local procedure against all linked server and...

Hi All, I want to run a job on one server by checking if a job on other server is finished (either case finishid success fully or failed). E.g I have 2 servers Server A jobX Server B joby on Server A (if jobX on Server A completed then start Joby) Thanks for the help in advance.

Hi All, is there any free to use code review tool for sql scripts? What are the options. Thanks

Hi All, I am looking for some sql query optimizer tool , which can suggest improvements (indexes, joins, etc) and point out week areas in term of performance and like that. I am using sqlserver 2016. Is there any free tool? Or I can take advantage of ssms. Any help? Thanks

Hi All, I am not sure this is appropriate forum. Struggling hard to find a way to hide or delete a thread. Please any body let me know if I want to hide a thread or a post due to some organizational information security then what to do? I really didn't find any admin contact options. please...

Hi All, I have IDs of following structure. 6000000107-1-0000000160-00000074281567 500004272696-1-0000000275-00000073969605 4500006358-1-0000000465-00000073971047 830452869878-1-0000002506-00000074349358 I need to extract digits from id from middle part, For example, for...

Hi All, I have the following query,it takes more than 10 minutes. How can it be optimized. please help. thanks DECLARE @InitDt AS date SELECT @InitDt = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-16, 0) ;with cte as ( SELECT ROW_NUMBER() OVER (PARTITION BY dim.Act_ID , dt.YEAR_NUMBER...