Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SevereIdea
- Order by date
-
Grabbing New Data From SERVERA.DB.View to SERVERB.DB.Table
Yep, that did the trick, thanks!! I added SERVERA to linked servers from EM on SERVERB and then wrote a stored procedure (sp_GetChecks) that I will now schedule to run twice a week. Thanks again! Dave- SevereIdea
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
Grabbing New Data From SERVERA.DB.View to SERVERB.DB.Table
I have two SQL Servers (SERVERA, SERVERB) On SERVERA I have a database (OGWIN) with a view (vw_zCutChecks). I created a one run DTS package that created a table (Checks) in a database (WTCHECKS) on SERVERB and imported all the records from that view. That was easy and worked perfectly, but now...- SevereIdea
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Data Transformation Services
