<div>
Thanks, guys. &nbsp;<br />
<br />
Turns out the error msg was generated because the script was trying to insert nulls into fields that were not setup to allow null values.
</div>


Thanks, guys.  

Turns out the error msg was generated because the script was trying to insert nulls into fields that were not setup to allow null values.

<div>
<div class="content wysiwyg-content">
We have a perl script running on Windows 2003 Server (called via Task Scheduler) that parses CSV files and inserts the records into a SQL 2000 database. &nbsp;<br />
<br />
The Task Scheduler Log (SchedLgU.Txt) states: &quot;Result: The task completed with an exit code of (9),&quot; which according to <a href="http://www.hiteksoftware.com/mize/Knowledge/articles/049.htm" rel="ugc">http://www.hiteksoftware.com/mize/Knowledge/articles/049.htm</a>, means &quot;The storage control block address is invalid.&quot;<br />
<br />
Any idea what might be causing this error or how we can rectify it?<br />
<br />
Thanks - Matt<br />
<br />
<br />
<br />
&nbsp;<br />

</div>
</div>


We have a perl script running on Windows 2003 Server (called via Task Scheduler) that parses CSV files and inserts the records into a SQL 2000 database.  

The Task Scheduler Log (SchedLgU.Txt) states: "Result: The task completed with an exit code of (9)," which according to http://www.hiteksoftware.com/mize/Knowledge/articles/049.htm, means "The storage control block address is invalid."

Any idea what might be causing this error or how we can rectify it?

Thanks - Matt



 


Task Scheduler Error

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.