Hi Muthyala,

Try entering the Linked Server name before the Schema name.

Select * From LINKEDSERVERNAME..SCHEMANAME.TABLENAME

Thanks,

Karthick.

Hi Koen,

I am sorry for taking so long to reply to your mail.

Yes i am getting a warning message if i run the Job in BIDS.

The message goes as follows:

"Warning...

Hi,

The password is storing correctly...

The Package is running successfully but its still giving the error message...

Yes...

and accessing that table through SQL Server authentication...

Hi,

Insert into Table2(Column1, column2,column3...)

Select (Column1, Column2, Column3, ...)

From Table1.

If they are in different databases then use as <DatabaseName.dbo.TableName>

Hi Guys,

Thanks for the reply.

Was help full...

Hi ,

Check the below functions they will help you...

CREATE FUNCTION [GetFirstDateofMonth]

(@Date as DateTime)

RETURNS DateTime AS

BEGIN

Declare @FirstDate DateTime

Set @FirstDate = DateAdd(Day, 1, @Date -...

Hi Mohan,

Open SSMS

Right Click on the Job you want and from the POP Up select Disable option.

To check after its been disabled the Job will be having an Red arrow...

I have three tables

Table 1 has fields -> [ID] , [Person Name]

Table 2 has fields -> [ID] , [Description]

Table 3 has fields -> [ID] , [Created (Date&Time)] , [Actual Finish...

It has a Constant Format in which it will appear,

And it is 36 Bit not 16 Bit and Each Digits can be of HexaDecimal Value From (0 -9) and...

Hi,

Generally Uniqueidentifier is a 36 bit alphanumeric unique Value that will not be duplicated.

Its syntax is XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.

It is a data type in SQLServer & it will be mostly used as...

FROM PRD_HEADER INNER JOIN PRD_Summary ON PRD_HEADER.PrdKey = acc_summary.PrdKey

INNER JOIN PRD_Unit ON PRD_Summary.PrdKey = PRD_Unit.PrdKey

Check this Join Condition...

Shound you be joining PRD_HEADER.PrdKey = PRD_summary.PrdKey instead of PRD_HEADER.PrdKey = acc_summary.PrdKey

Can you Paste the Exact Result that you are expecting...?

Can You Explain Your requirement more...

What is the purpose of that Complex Case Statement?

Gan you explain a Bit...

This Is Possible Using Linked Server's But cannot say If this is what you are expecting, Explain your need?