We are upgrading from sql server 2000 to sql server 2005. I am trying to move an xml script that sends out an email every morning with pdf attachements.
Here is the code:
The error log is giving this error:
14-7-2010 START TIME: 9:33:16
# Attachments: 1
Error Logging onto Server: Invalid directory.
The directory that the files are in is:
C:\Powerview\rpt\Custom\Scheduled\Dynamic
But on the old server the xml script line reads:
\\servername\reports\Scheduled\Dynamic\minekpi_dynamic.rpt
And the old directory is:
C:\Powerview\rpt\Scheduled\Dynamic\minekpi_dynamic.rpt
So what is the directory path supposed to be? I have never worked with XML before and am not finding any good resources on the web.
The email will go out if you do not add any attachements.
Thanks very much
Here is the code:
Code:
<?xml version="1.0"?>
<!--XML writer for DataGridView Control-->
<XML>
<schedule id="1">
<fileSettings attachment="1">
<inputPath>\\servername\Custom\Scheduled\Dynamic\minekpi_dynamic.rpt</inputPath>
<outputPath>ExportFolder\MineKPI</outputPath>
<outputFileSuffix></outputFileSuffix>
<fileFormat>pdf</fileFormat>
<printer>
<enabled>false</enabled>
<printerName>\\mkgmin-s-001\MKG0P091</printerName>
<printerDriver></printerDriver>
<portName>IP_161.19.204.242</portName>
<copies>1</copies>
<collate>true</collate>
<orientation>portrait</orientation>
<paperSize>letter</paperSize>
<printDayOfWeek>Mon,Tue,Wed,Thu,Fri</printDayOfWeek>
</printer>
<printer>
<enabled>false</enabled>
<printerName>\\mkg-s-001\MKG0P089</printerName>
<printerDriver></printerDriver>
<portName>IP_161.19.204.256</portName>
<copies>1</copies>
<collate>true</collate>
<orientation>portrait</orientation>
<paperSize>letter</paperSize>
<printDayOfWeek>Mon,Tue,Wed,Thu,Fri</printDayOfWeek>
</printer>
</fileSettings>
<crystalSettings attachment="1">
<parameter name="@endshiftTemp">0</parameter>
<parameter name="@spanshiftTemp">1</parameter>
</crystalSettings>
<frequency>
<period>daily</period>
<runTime>07:15:00</runTime>
</frequency>
<email>
<from>reports@xxx.com</from>
<to>xxx@xxx.com</to>
<!--
<subject>Daily Production Reports</subject>
<body>Attached are the Mine KPI reports. Note: this email is scheduled to be sent daily at 6:30 AM. Contact Me for support.</body>
</email>
</schedule>
<connection>
<dataSource>servername</dataSource>
<catalog>DB</catalog>
<userid>xxxx</userid>
<password>xxxxx</password>
</connection>
<smtp>
<smtpHost>emailservername</smtpHost>
<smtpPort>25</smtpPort>
<smtpWelcome>xxx</smtpWelcome>
<userid></userid>
<password></password>
<defaultCreds>true</defaultCreds>
<deliveryMethod>Network</deliveryMethod>
<ssl>false</ssl>
</smtp>
</XML>The error log is giving this error:
14-7-2010 START TIME: 9:33:16
# Attachments: 1
Error Logging onto Server: Invalid directory.
The directory that the files are in is:
C:\Powerview\rpt\Custom\Scheduled\Dynamic
But on the old server the xml script line reads:
\\servername\reports\Scheduled\Dynamic\minekpi_dynamic.rpt
And the old directory is:
C:\Powerview\rpt\Scheduled\Dynamic\minekpi_dynamic.rpt
So what is the directory path supposed to be? I have never worked with XML before and am not finding any good resources on the web.
The email will go out if you do not add any attachements.
Thanks very much