December 2, 2010 at 4:33 am
Well folks, I'm trabalahndo with DTS to SSIS migration and found the following situation:
_Make A Sql Task in DTS with the following contents:
INSERT INTO dbo1.Cliente
SELECT id, col_2
FROM dbo2.Perfil
WHERE col_2 = 'u' AND ID NOT IN (Select ID from Client)
In this sql it inserts the data from a another table in another database table Customer, provided that there are at cleint.
Use the SSI 2005 which I'm still learning.
Can someone help me with this? Thanks!
December 3, 2010 at 6:22 am
I don't understand the question...
December 3, 2010 at 11:10 am
If I understood this correctly, you're basically just starting to use SSIS at all, and you need a beginner's guide.
Create some sources at the bottom, connecting to the different database. Drag a data flow task from the left into the main workspace. Doubleclick this to enter it, and then create the source/target objects, and drag the green line from the source to the target. Then enter each structure and work with the settings.
That's the short form.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply