even I thought so, but when I observe it with performance counter Bufferused remains at a constant value when UI stops reading that indicates nothing is happening
It might not...

Source is SQL and destination is also SQL, I am using OleDB source, but connection is to a SQL Server Database

Thanks Aaron for your reply, there are no transformations involved, one oledb source which has Select <columnlist> from <viewname> and oledb destination , to test if it is a read...

Thanks for bringing it to m notice, I uploaded it now.please check now.

Create a Object variable

Use Execute SQL Task to Copy the Output of Select <ColumnnameWhichhaspath> from <Table>

into this Object Variable

Use foreach ADO.net enumerator and Loop through all records in...

I used WAITFOR to achieve the same instead of script.

thanks for your idea.

Hi Koen,

thanks for your reply.

I need to send an email only in-case the data load(DFT) takes more than 10 minutes(or a specified interval),and it is still in execution but not...

AutoGenrating Identity solves,but the data is in Text file and there are around 700 files which needs to be processed

Hi Brandie,

If I add a Merge Transform and Pull the Data into Destination,Data from each file Merges as one column in the output,what I need is a separate column for...

with cte as

(select MenuID,MenuDesc,ParentMenu

,Sequence,1 as Lev

from Menus

where ParentMenu is ''

UNION ALL

select m.MenuID,m.MenuDesc,m.ParentMenu

,m.Sequence,Lev+1

from cte

join Menus m

on m.ParentMenu=cte.MenuID

)select MenuID,MenuDesc,ParentMenu,

ROW_NUMBER()OVER(partition by ParentMenu order by Menuid) as [Sequence]

,ROW_NUMBER()over(order by Lev) as [Order]

,Lev

from cte

this...

Hello,

can you check using the below query

if the query is not okay,can you explain a bit about Order Column

with cte as

(select MenuID,MenuDesc,ParentMenu

,Sequence,1 as Lev

from Menus

where ParentMenu is null

UNION ALL

select m.MenuID,m.MenuDesc,m.ParentMenu

,m.Sequence,Lev+1

from...