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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy SQL server Objects task doesn't copy data

Status
Not open for further replies.
SpiderFlight

SpiderFlight

Programmer
Aug 22, 2001
37
US
Hi everyone, I am hoping one of you SQL gurus can help me with this. I am developing on SQL 2000 and have a DTS process that contains a Copy SQL Object Task. When I execute this step manually the process tells me it was successfully executed. However, when I go verify there is no data copied, just the table and structure. When I execute the same step on the server the data is copied. Has anyone experienced this before? Any help resolving this is greatly appreciated.
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
345
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
753
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
928
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
518
Chris Miller
Chris Miller
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
875
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top