Home > IT Answers > SQL Server > SSIS package that will copy a table from one ...
Help

Question

Asked:
Asked By:
Dec 3 2008   10:21 PM GMT
NewBee7   105 pts.

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Dec 4 2008  10:43 AM GMT  by Mrdenny   41270 pts.




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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

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!