Great Article Lynn

I also wrote something similar long time back on my blog....

http://mohitnayyar.blogspot.com/2008/09/data-extrapolation-on-fly.html

Thanks

Mohit

Yes, this is very much clear for everyone who understands CTE.

I am creating the temp. table to DEMO the functionality. But in real world case you will use the actual table. So not temp. table required for extrapolation.

Please let me...

SELECT

ROW_NUMBER() OVER (PARTITION BY [name] ORDER BY dept, name) AS Seq

, *

FROM TableName

You can achieve the same using standard T-SQL with these steps, but I would like to inform you that I am making some really BIG assumptions, so please go through...

You might be saving some sensitive (connection password etc.) data inside the package and this data is being encrypted by your windows user profile. That means if...

See, if we have cursor in SQL Server then they must be of some use.

So it depends on the business / technical requirement and our capability of using...

http://support.microsoft.com/default.aspx/kb/918760

I guess this link will be useful for you, I had the same SSIS issue sometime back and that was the easy fix.

Hi

Check your package property "ProtectionLevel" and see What is it? Package password is stored in "PackagePassword" property. I am sure playing with these 2 properties will definitely solve your problem.

I...

Hi

The use of standard configurations is always useful and this can be very beneficial while deploying the package to another location (QA, TEST, and Production).

Environment variable

Always use the environment variable...

Thanks guys

But We cannot go ahead with application roles as more than 10 different applications uses this db and they are legacy apps.

The DTS option is great, but what if...

Thanks David

They all are the administrator or in someway related to top level management. They use excel because of easyness but it creates lots of problem for production environment.

We don't...

Hi Steve

Ya, the solution is great, even I thought the same thing. But we should not play with system tables. I am still searching and let you know.

Otherwise we will go ahead...

We can try this with time

select dateadd(dd, -day(getdate()), getdate()) as Last_Day_Previous_Month,

dateadd(dd, -day(getdate())+1, getdate()) as First_Day_Current_Month,

dateadd(mm, 1, dateadd(dd, -day(getdate())+1, getdate())) as First_Day_Next_Month

Thats OK.

But i would like to merge the content of publisher and subscriber at both ends. I haven't got any help on this topic.