Post reply

SSIS easy answer if anyone has done this 1 time - how to run an ssis package from a query window

  • September 24, 2009 at 9:29 am

    #205071

    Ran this:

    Declare @cmd varchar(1000)

    select @cmd = 'dtexec /F " D:\Development\Blair_Claims_Upload\Blair_Claims.dtsx"'

    exec master.dbo.xp_cmdshell @cmd

    Got This:

    error description

    Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.

    I keep seeing in google about this package installation wizard. but where is the wizard,

    from where is it initiated.

  • September 24, 2009 at 12:26 pm

    #1058208

    I would appreciate greatly to know atleast were the package installl wizard is located if know one has had this error with the XML

    thanks

  • September 24, 2009 at 12:35 pm

    #1058213

    In BIDS< right click on the Project, select Properties.

    In the Configuration Properties tree, select Deployment Utility. Change the value from False to True for CreateDeploymentUtility. You can also specify where it gets created with the DeploymentOutputPath.

    HTH,

    Steve.

  • September 25, 2009 at 6:30 am

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply