Help with DTS PACKAGE
I need some help or Guidance with DTS!
What I need a to Exec a Stored procedure from DTS.
This Truncate a table then pull data and Repopulates the table.
I then need to push all that data to a remote SQL Server Table.
How do I create a connection to DB and one table.