using Microsoft.SqlServer.Dts.Runtime should be there in the namespace list.

I believe there is a better way to this.

--(Employee) (Allocated_From) (Allocated_To) (Allocation)

--(E1) (2014-08-08 ) (2014-09-07) (36)

--(E1) (2014-09-08 ) (2014-10-30) (76)

--(E1) (2014-11-01 ) ( 2014-11-30) (40)

;with Employee(Emp,Project,Allocation,Allocated_From,Allocated_To)

as (select 'E1','P1',36,'2014/08/08','2014/10/30'

union all

select...

Not able to figure out how to handle the allocation. Can some one take it fwd to the final solution.

--(Employee) (Allocated_From) (Allocated_To) (Allocation)

--(E1) (2014-08-08 ) (2014-09-07) (36)

--(E1) (2014-09-08 ) (2014-10-30)...

sp_help[spname] already do that job. you have any specific reason to do that in the sp with an additional parameter.

tdanley (8/29/2014)

---

I am using the File System Task to rename a file. Once it's renamed I need to FTP that file. When I put my variable in the FTP task...

We cann't change the data type for existing columns but you can always...

I don't understand whythat is not working for you in the Derived Column Transformation .

I used exactly the same...

SELECT distinct jNMBR, sNMBR FROM #myTable

WHERE cDate IS NOT NULL

rxm119528 (8/27/2014)

---

As per my understanding of the requirment

with CTE AS(select * from dbo.test where diagnosis = '427.31' and DiagnosisSeqID>1

union all

select * from dbo.test

where DiagnosisSeqID = 1 and diagnosis...

Can you upload the sample CSV file. I am not able to reproduce the problem.

As per my understanding of the requirment

with CTE AS(select * from dbo.test where diagnosis = '427.31' and DiagnosisSeqID>1

union all

select * from dbo.test

where DiagnosisSeqID = 1 and diagnosis in...

First In your SSIS package you are going to save you row count into variable (for example vartotal).

Then when you open the script task editor, in the script section you...

with CTE(rn,steps)

As

(

select row_number() over ( order by steps),steps from #table1)

select t1.steps,t2.steps from CTE t1

left outer join CTE t2

on t1.rn =...

I am able to bring it to this level.

Not getting how to handle the nulls in unipovt.

May be someone will be have a better answer.

declare @sample table(

NHS_NUMBER_ANON varchar(14),

NHS_NUMBER...

declare @d datetime = '2/1/2014 05:28:13 AM'

select dateadd(HOUR,-3,@d)