Thank you, Sue. Had heard about the deprecating story earlier and was surprised :). Good they are retaining it even if its a newer version.

You may want to use this combination <fast forward, local>

Reference I read few years earlier: https://sqlperformance.com/2012/09/t-sql-queries/cursor-options

thanks. But I wouldn't consider this incremental. May be "individual package deployment". 
Incremental would be something where we (or the program) can identified the diff and deploy only the packages...

STATS_DATE ( i.object_id , i.index_id ) as IndexCreatedDate
STATS_DATE can't be the IndexCreate date; Per BOL, "Returns the date of the most recent update for statistics on a table or...

Anyone?

Thanks guys.

Thanks Howard

Its just that a business logic is written in the current SP based on the output of the patindex. If I have to rewrite the code based on corrected...

Yes...

For now, these are the only 2 work arounds i see.

Thanks

Sandeep

Hi,

Few examples for sensitive data:

1. Database connection string (including user name/pw)

2. Server credentials for SMTP/ FTP etc

Ideally, we will be using windows authentication for database connection string; but not all...

Thanks....

I have done the first part i.e, using a data flow task and getting the list of values (a set of Contract Keys in my example).

I am not quite...

Thanks John and Amit..

That helped a lot...

Thanks John...

I am using SQL 2000.

Here is the script which will generate sample source resultset:

IF OBJECT_ID('Hotel') IS NOT NULL

DROP TABLE Hotel

CREATE TABLE dbo.Hotel(

hotel_id INT,

hotel_name VARCHAR(100),

facilities VARCHAR(100)

)

GO

INSERT INTO Hotel

SELECT 456,'BASIL...