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 |
|
abhwhiz
Starting Member
37 Posts |
 Posted - 2007-08-08 : 00:29:32
|
| Friends,I was writing an SSIS package to import data from a table in a remote server to my local. I scheduled a job to do the same. The job failed and i tried fixing it. I couldnt do it, now, whatever job i create for the package it is all going into a "suspended" mode. The job starts running, then it will show "suspended". I am not able to understand this, i read couple of articles/blogs, one said it is a bug. Is this information correct? I there anything else wrong here? Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-08 : 05:45:15
|
| Do you have sp2 installed? There were fixes for this in that. It would need to be installed on all sql server machines involved.Are you running the 64 bit version?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
abhwhiz
Starting Member
37 Posts |
Posted - 2007-08-08 : 09:14:44
|
| 1. sp2 is not installed.2. no, i am not using 64-bit.I will install sp2 and test the package again. Thnx a lot!! |
|
|
|
|
|
|
Job goes into "suspended" mode