Here is an example query to do it

Declare @day date

set @day = '2012/01/29'

select @day

Select DAY(@day) as Noofdays

SELECT DATEADD(mm,1,DATEADD(dd,-(DAY(@day)-1),@day)) AS Day

Select DATEADD(yy,1,DATEADD(dd,-(DAY(@day)-1),@day)) as Day

Did you ever solved this problem??

I have the same issue now.

My ssis package works fine in 2005 but when upgrade and run in 2008 i get the error

" Unable to...

This one works perfect but can you tell me how for XML works??

I am planning to use pgp encryption.

at the decryption side they will use the pgp software to decrypt the file

ya its a dimension table

but for a single product there should be only one id.

no history at all...

I have attached the sameple records of the fact and dimension table.

So instead of updating pdesc for pid=1 in the dimension it created a new pid=4

same is the case for...

for a single product instead of updating a single field in a row its creating a new row for the same product.But here we are not keeping any history.

For...

This one is old DWH.

there is a primary key on the dimension table and composite keys in the fact table.

i am using SSIS

i am able to fix the package but...

u can create a execute sql task and create a variable to pass input value and also assign the variable to the parameter using the parameter mapping

in the execute...

Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does not support Idea. Do you need...

I am using SQL Server 2005

I looked at some articles to use the script and i was thinking of any open sources to do that..

@phil

If i remove the ? and hardcode the task...

Its working perfectly

There are a lot but thats fine......

The thing is i am unable to map the parameters correctly

Thanks John

i found a article

http://consultingblogs.emc.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspx