June 2, 2010 at 12:58 pm
First, let me say this was not my project, I am just helping out because that admin is no vacation.
Apparently about a month ago a server was migrated from SQL2k/Server 2003 to SQL2k5/Server2008 (clustered). They migrated over the DTS packages.
Now when trying to execute it for them, I am getting an error. The step is a step that copies the data from the flat file to the database. Everything in the step looks fine (I can previews, all columns matchg up).
When that step is executed in the package, thou I get:
error Source: Microsoft DTS Package
Error Description: Error Code: 0
Error Source: microsoft VBScript runtime error
Error Description: File Not Found
Error on line 34
There is no VBScript in the package, so all I can figure is that it's refering to the underlying DTS code. Incidentally, the package does work in QA (but QA is a non-clustered server 2003 box)
Any ideas?
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
June 2, 2010 at 2:18 pm
One thing you can try is run the steps in the package individually one by one, so that you would know at what step is the DTS (Now SSIS) package is throwing the error.
At that point, I would recomend you take a closer look at the step at QA and prod where you have this error. I assume that particular step is reading/writing/logging info to a file or a folder which is missing in prod.
Have you checked that?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
June 2, 2010 at 3:01 pm
Are we sure the version in QA is EXACTLY the same as the prod version. Also, does the package call any other packages. However, I did have another thought.. Data pump transforms CAN be done with an ActiveX script, so you need to look at the data pump mappings to see if any of them use ActiveX scripting.
CEWII
June 2, 2010 at 3:32 pm
That was it, when I dud down into the data pump, I found that the person set it up with an Active-X script to verify the existance of the file. Thanks
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
June 2, 2010 at 4:05 pm
Super, glad to hear it.
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply