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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
copy log to diff server
Look like your going down the right path! If you wish to copy files over server through xp_cmdshell you have to be running the SQL Server agent as a domain account with rights to all servers involved. LocalSystem will not work. That's where I would start. -derek- STLDROCK
- Post #2
- Forum: Microsoft SQL Server: Programming
-
MS Replicated table to a staging table.
I'll answer my own question. Hopefully others will get something out of it. Here's what we have done. First we made duplicate articles in the publication. One article points to the exact same table like we have always done. The second points to a Staging table. For example we have the...- STLDROCK
- Post #3
- Forum: Data Warehousing/Big Data
-
MS Replicated table to a staging table.
I need some help designing a technical document for our upcoming ETL package. The current system transactionally replicates a table from the Transactional System to a Reporting environment. Now we want to start using MS Intergration Services to load Dimensions from views from the...- STLDROCK
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
