Post reply

Can''t See SQL Server Integration Services Package In List

  • August 19, 2007 at 12:01 pm

    #125282

    I have created a package and depolyed it to my server (File System), I now want to create a job to execute it but I cannot see the SQL Server Integration Services Package option in the Type list.

    Any ideas?

  • August 20, 2007 at 3:19 am

    #727900

    Hi David,

    When you try to create the job, you make it from the server or the client?

  • August 20, 2007 at 4:22 am

    #727911

    I use SSMS that is installed on my client machine

  • August 20, 2007 at 4:25 am

    #727913

    Can you try to make the sames steps but with a remote desktop connection into the server?

  • August 20, 2007 at 4:54 am

    #727917

    How strange, on the server the option is there?!

    Why would the job type be available on the server but not on the client??

  • August 20, 2007 at 5:05 am

    #727918

    The main reason is SSMS.

    When you try to make a new job (File System package) from the client, SSMS find local packages to the server. If you deploy a package as File System, you can not view this package outside the server.

    Instead deployig packages as filesystem, try to deploy as SQL. Then, you can use SSMS from the clien machine.

    Sorry for my English. I'm from Spain

  • August 20, 2007 at 6:03 am

    #727927

    Ah, I see!

    Thanks for your help Alex. Your English is much, much better than my Spanish!

Viewing 7 posts - 1 through 6 (of 6 total)

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