You can use BCP.exe utility to import the result from the file into a table.

coldfire101 (12/30/2009)

---

Is there any way by which I can put the Query Results into a new table after executing it,So I can run some queries against the data (in the...

You can get the RowID by sing the 'inserted'/updated table. This table is accessible in triggers during an Insert, Update and Delete operation.

The update scenario is something like this:

...

You are welcome.

SELECT clientname

FROM #ABC

ORDER BY SUBSTRING(clientname,3,3)

,SUBSTRING(clientname,1,2)DESC

Try this:

Go to the Advanced Editor of the OLEDB destination task under Component Properties there is a property called 'FastLoadOption' add FIRE_TRIGGERS in that property.

Yes. A real good catch:-)

As Imu said, send us what are you trying to do?

You won't get any data because you are not selecting any. In your code you are only assigning values to the variables. To get the output you have to select...

Thanks Lynn!

vikas bindra (12/21/2009)

---

Lynn Pettis (12/21/2009)

---

vikas bindra (12/21/2009)

---

declare @lastFriday datetime

SET @lastFriday = convert(datetime,convert(varchar(10),getdate() - (datepart(w,getdate())+1),121))

select

@lastFriday - 6

,@lastFriday - 5

,@lastFriday - 4

,@lastFriday - 3

,@lastFriday - 2

,@lastFriday...

Lynn Pettis (12/21/2009)

---

vikas bindra (12/21/2009)

---

declare @lastFriday datetime

SET @lastFriday = convert(datetime,convert(varchar(10),getdate() - (datepart(w,getdate())+1),121))

select

@lastFriday - 6

,@lastFriday - 5

,@lastFriday - 4

,@lastFriday - 3

,@lastFriday - 2

,@lastFriday - 1

,@lastFriday...

declare @lastFriday datetime

SET @lastFriday = convert(datetime,convert(varchar(10),getdate() - (datepart(w,getdate())+1),121))

select

@lastFriday - 6

,@lastFriday - 5

,@lastFriday - 4

,@lastFriday - 3

,@lastFriday - 2

,@lastFriday - 1

,@lastFriday

You are welcome..

You only need to map the "Result Set'.

Parameter mapping is for the input parameters for the query and your query does not accept any parameters it is a direct SQl...