Comments by Rohit Lal

Rohit Lal 29-Dec-16 3:43am View

I am getting below error while in web service url. As a normal user this user can not access the directory.

The permissions granted to user 'Domain\User' are insufficient for performing this operation. (rsAccessDenied).

Rohit Lal 28-Dec-16 3:56am View

I am getting below error while in web service url. As a normal user this user can not access the directory.

The permissions granted to user 'Domain\User' are insufficient for performing this operation. (rsAccessDenied).

Rohit Lal 23-Dec-16 0:23am View

Anyone to help

Rohit Lal 22-Dec-16 9:21am View

Please help

Rohit Lal 7-Jul-16 2:49am View

Hi,

I am using Microsoft oledb provider for db2 v.2 to connect vb script. I think Oledb provider for db2 v.2 not compatible with db2 v10.5. Any idea on the same.

Rohit Lal 24-Jun-15 4:02am View

Any other solution ?

Rohit Lal 19-Jun-15 9:25am View

Not able to find COLLATION KEY in DB2

Rohit Lal 19-Jun-15 3:29am View

Hi Andy,
I am getting two error while running HOT fix

Error-1
The version of SQL Server instance Shared Component does not match the version expected by the SQL Server update. The installed SQL Server product version is 10.0.1600.22, and the expected SQL Server version is 10.1.2531.0.

Error-2
[Error Message]
There are no SQL Server instances or shared features that can be updated on this computer.

Can you help on the same.

Rohit Lal 18-Jun-15 10:25am View

Hotfix applied but still facing this issue

Rohit Lal 18-Jun-15 9:30am View

Still showing same error.

Rohit Lal 18-Jun-15 9:28am View

DB2 SP HELP

NAME TBNAME COLTYPE NULLS CODEPAGE DBCSCODEPG LENGTH
ALARMCODE REPORTER_STATUS VARCHAR Y 1208 1200 12
CIRCLENAME REPORTER_STATUS VARCHAR Y 1208 1200 15
CLUSTER REPORTER_STATUS VARCHAR Y 1208 1200 25
NODE REPORTER_STATUS VARCHAR Y 1208 1200 64
SITEID REPORTER_STATUS VARCHAR Y 1208 1200 45

SQL SP HELP

Column_name Type Computed Length Prec Scale
CIRCLENAME varchar no 15

NODE varchar no 64

SITEID varchar no 45

ZONE varchar no 20

CLUSTER varchar no 25

ALARMCODE varchar no 12

No triggers found in both side (source and destination table).
I am new to this.

Rohit Lal 18-Jun-15 7:22am View

Query
===============FIRED ON SOURCE TABLE
SELECT
CIRCLENAME,NODE,siteid,zone,cluster,ALARMCODE, evnttime,CLEAR_TIME,FIRSTOCCURRENCE,LASTOCCURRENCE,LOGTICKET
FROM DB2CDC. REPORTER_STATUS WHERE
(EVNTTIME BETWEEN '2015-06-15-00.00.00.000000' AND '2015-06-15-23.59.59.000000')
WITH UR
==========DATA TYPE IN DB2=====
CIRCLENAME (VARCHAR(15))
NODE (VARCHAR(64))
SITEID (VARCHAR(45))
ZONE (VARCHAR(20))
CLUSTER (VARCHAR(25))
ALARMCODE (VARCHAR(12))

Truncation only happened in above column. I have specified the same column and data type in sql table.

Rohit Lal 18-Jun-15 7:22am View

Query
===============FIRED ON SOURCE TABLE
SELECT
CIRCLENAME,NODE,siteid,zone,cluster,ALARMCODE, evnttime,CLEAR_TIME,FIRSTOCCURRENCE,LASTOCCURRENCE,LOGTICKET
FROM DB2CDC. REPORTER_STATUS WHERE
(EVNTTIME BETWEEN '2015-06-15-00.00.00.000000' AND '2015-06-15-23.59.59.000000')
WITH UR
==========DATA TYPE IN DB2=====
CIRCLENAME (VARCHAR(15))
NODE (VARCHAR(64))
SITEID (VARCHAR(45))
ZONE (VARCHAR(20))
CLUSTER (VARCHAR(25))
ALARMCODE (VARCHAR(12))

Truncation only happened in above column. I have specified the same column and data type in sql table.

Rohit Lal 18-Jun-15 7:15am View

Deleted

Thanks for your help

Rohit Lal 28-Mar-15 4:37am View

Pls help

Rohit Lal 23-Feb-15 6:17am View

Scheduler will run the whole package, I want this package to be run twice in a day and according to time it will the execute task.

Rohit Lal 23-Feb-15 5:38am View

One SSIS Package with two process task, SSIS first check time and accordingly execute task. if time 8:20 then only run task which needs to be run at 8:20 or if time in 4:20 then another one should be executed.

Rohit Lal 23-Feb-15 5:34am View

Scheduler will run both task...for that I need to create two different task...in ssis first check time then execute task

Rohit Lal 20-Feb-15 13:04pm View

Do I need to save the password and reopen the connection

Rohit Lal 20-Feb-15 4:43am View

Pls Help

Rohit Lal 7-Feb-15 12:50pm View

What could b the reason

Rohit Lal 7-Feb-15 12:25pm View

Sorce and destination both have varchar 12

Rohit Lal 7-Feb-15 12:23pm View

Pls help

Rohit Lal 7-Feb-15 12:22pm View

Pls help in it

Comments by Rohit Lal (Top 24 by date)