Im trying to run a sql script as part of a custom package but cannot get it to run.

Ive stripped the package down to the basics and it still will not work.

Package details :

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<umbPackage>
  <files />
  <info>
    <package>
      <name>ContactUs</name>
      <version>1</version>
      <license url="1">1</license>
      <url>.</url>
      <requirements>
        <major>3</major>
        <minor>0</minor>
        <patch>0</patch>
      </requirements>
    </package>
    <author>
      <name>1</name>
      <website>1</website>
    </author>
    <readme><![CDATA[]]></readme>
  </info>
  <Documents />
  <DocumentTypes />
  <Templates/>
  <Stylesheets />
  <Macros />
  <DictionaryItems />
  <Languages />
  <DataTypes />
  <Actions>
    <Action runat="install"
undo="false"
alias="ExecuteSql">
      <![CDATA[CREATE TABLE tmp22 ( [ClientCategoryId] [int] IDENTITY(1,1) NOT NULL)]]>
    </Action>
  </Actions>
</umbPackage>

Ive run the script manually through management studio using the same login creditials as the website and that runs fine.

Any help appreciated

Steve