Search results for query: *

Hello, I have issues with SSRS 2019. I moved SSRS 2012 to 2019 on OS 2019,. after restoring key ssrs comes up fine. But when i try to create oracle data source it errors out with TNS: could not resolve the connection identifier specified. I have oracle 2019 client installed. also installed...

Hello, new to ssis so wanted to find out how to compare the data in the destination then get data from source and insert into destination what exist for example i have set of record id in the destination. based on that i need to bring that record id only from source to destination...

Hi all, How can i send Daily history of job to email please.!! thanks

Hi all, I am having one problem about the processing cube in SQL 2005 AS. when cube runs i get this error in log file: File system error: Error opening file; \Program Files (x86)\Microsoft SQL Server\90\Shared\ASConfig\msmdredir.ini is not a disk file or file is not accessible.

Hi i am trying to query oracle from SSRS and so far successful but when i try to do this: select testname, testid from test where testname like '%'+upper(?) +'%' then get error saying that invalid number i know i could do something like that in SQL but having trouble in oracle! i am doing...

Hi i am trying to query oracle from SSRS and so far successful but when i try to do this: select testname, testid from test where testname like '%'+upper(?) +'%' then get error saying that invalid number i know i could do something like that in SQL but having trouble in oracle! i am doing...

I get this error also The return value was unknown. The process exit code was -1073741795. The step failed.

Hi, I am trying to run simple import export package and if fails saying that pacage execution failed. then i try using File system and the error say that it is not 32 bit driver and execution failed. thanks

somehow they have not give me rights and they use some connection with different for oracle Database. But everything works fine if i don't include parameter. but I would like to have parameter so I can have search capacity in report. I used ? for parameter but did not work. i also tried using...

Hi, I could not have direct access to oracle database and have Access database that has linked table to Oracle. i tried using (where user_NM like ?) did not return anything. and also tried where user_NM like '%?%' and it did not work. thanks

yes I am using SQL Reporting Sevices to create reports.

Hi, I want to use parameter and would like get result like this I have access file that has linked tables of oracle database. I am trying to create prameter but oracle doesn't like named parameter so I am trying to use " ? " as parameter. I have query similier to following: select user_NM...

try restarting Reporting services then IIS

hi all, I am tryng to run package to export data from one db to another. but when i set up as a job if fails by saying that --> An error has occurred during report processing. Cannot create a connection to data source 'INVC'. For more information about this error navigate to the report server...

Hi all, I am trying to view report that i deployed to reporting service but when i try to view it, it gives error: An error has occurred during report processing. Cannot create a connection to data source 'INVC'. For more information about this error navigate to the report server on the local...

Hi all, i have following query and trying to do union but get result different ( SELECT Mrev = '', SUM(testitem.cramount) - SUM(testitem.DebAmount) AS annualtest, DAY(test.date) AS day FROM test AS test WITH (NOLOCK) INNER JOIN testItem AS testItem WITH (NOLOCK) ON test.testKey =...

if it try do join it give me following error The multi-part identifier "t.testid" could not be bound.

but that proc can process one testid at a time. exec testproc @id = '1234' Thanks

hi i have view that have all the columns selected and have stored procedure that give calculated amount. how can i get total result combine with all the result with both view and column., is it advisable to create cursor!!! declare @id bigint DECLARE Employee_Cursor CURSOR FOR SELECT testid...