I was able to load the data using these steps.

1. Execute SQL Task - Get the data and load it into a table in
Tempdb (Server B).
2. Data Flow Task - Retrieve the server Name and additional info
(Server A), retrieve the space data (Server B), union the data together,
and save the data to server A.
3. Execute SQL Task - Drop the table in Tempdb (Server B).
4. Execute SQL Task - Update the data (Server A).

I tried to use the merge task to join the data together but was getting
all sorts of sorting errors. I read that you should use the union task
whenever possible.


Stephen Anderson
(763) 494-2441
(763) 494-2541 Fax
www.BostonScientific.com
[Email address protected]

-----Original Message-----
From: Stephen Davey
[mailto:mssqldba-ezmlmshield-x19158156.[Email address protected]
Sent: Friday, August 31, 2007 8:52 AM
To: LazyDBA Discussion
Subject: Re: SSIS - Data flow task

Steve,

Have you tried to insert your result set directly into the ServerB table
using a fully qualified table name insert, for example,

INSERT serverb.targetdb.dbo.servrbtbl(servername, drive, [freespace])
SELECT atatServerName AS ServerName, Drive, [FreeSpace]
FROM lbstblDriveSpaceTemp

Link ServerA and ServerB and the above should work.

The Hard Working SniperBot is trapping my response, so I've not included
the question to see if I can sneak this in, also removed the "at" and
"lbs" signs.

S. Davey (8/31)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page