Query from Source not sure how to get into Destination

Question

Query from Source not sure how to get into Destination

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27164 More actions · Answer 1

How about linked server?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Phil Parkin SSC Guru Points: 247183 More actions · Answer 2

Don't like the cursor. Can you run something like this?

SELECT o.name,

ddps.row_count

FROM sys.indexes AS i

INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID

INNER JOIN sys.dm_db_partition_stats AS ddps ON i.OBJECT_ID = ddps.OBJECT_ID

AND i.index_id = ddps.index_id

WHERE i.index_id < 2 AND o.is_ms_shipped = 0 ORDER BY o.NAME

If yes, use it as an OLEDB source in a dataflow. Then you can fire the results where you want.