Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mshsilver
Posting Yak Master
112 Posts |
 Posted - 2009-07-20 : 09:41:10
|
| Hi,I have just built my first DTS package which transfers data from one SQL 2005 database table to another SQL 2005 database table on another server. The table layouts are identical in everyway. When I execute the package using the debug mode in SQL Server business intelligence development studio the 110,000 rows transfer perfectly.My issue is when I try and setup a SQL job which I have not done before it say it ran and executed. When I check the destination table there is no data so I must have done something wrong or be missing a key setting when building the job.I have Googled and tried altering the configuration but seem to be getting know where. If anyone could please point me in the right direction or ask me questions about my setup and help me track a solution I would be most grateful.Thanks in advance. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-07-22 : 10:15:05
|
| Check history for any error(s). Do you get succesful job result? |
 |
|
|
|
|
|
DTSX Package and SQL 2005 Job