SSIS package that will copy a table from one server to another based on a var.
Home > IT Answers > SQL Server > SSIS package that will copy a table from one ...
NewBee7
105 pts.
0
Q:
SSIS package that will copy a table from one server to another based on a var.
SSIS Package
Another NeeBee question....I would like to have an SSIS package that would check if a variable "RefreshTable" = 'YES' which is found on a table from server A, delete all the data from a table on server B and then load that table on server B with data from an identical table which is on server A. All tables and servers are SQL 2005.
ASKED: Dec 3 2008  10:21 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
This can be done very easily.

Setup a Script task and if the dts.variables.item("RefreshTable").value = 'YES' then stop the package, otherwise mark the task as successful which will allow the package to continue.
Last Answered: Dec 4 2008  10:43 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

NewBee7   105 pts.  |   Dec 4 2008  10:57PM GMT

That would be fine but I (NewBee) don’t know <a href="http://vb.net" title="http://vb. " target="_blank">vb.net</a> … Is there any code that I can look at that is simmilare???? Thanks!

 
0