not registered for use on this computer

  • I created a dtsx and copied it to our server. When opened the dtsx to edit it on the server I got

    lot of Error loading task and when i clicked on a task it said

    The task named... is not registered for use on this computer.

    how do i fix this?

  • I had this same issue and found the solution from here:

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ef6ac593-ae9d-4875-9060-db183b6fd4ed

    This problem occured probably, you use username and password to log on to your computer, so sql server need to verify the user who authorized to use the sql server service.. But sometimes sql server cannot redirect to the account, so we need to configure the user.

    Here's the step :

    1. open sql server configuration mangager

    2. choose sql server 2005 services

    3. right click sql server integration services, choose properties

    4. choose log on tab, select this account, enter your username and password which is used to log on your computer.

    5. reopen the business intelligence studio. There you are, the data flow task component can work properly again.

  • ok by mistake i created the dtsx in sql server 2008 BIDS and trying to open in 2005.

    my dev machine has both versions and the server has only 2005.

    Is there a way for me to convert 2008 to 2005? i am not able to copy task by task too.

    thanks

  • AAAV (4/14/2010)


    ok by mistake i created the dtsx in sql server 2008 BIDS and trying to open in 2005.

    my dev machine has both versions and the server has only 2005.

    Is there a way for me to convert 2008 to 2005? i am not able to copy task by task too.

    thanks

    Can't be done.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • yes i realised it so redid the full thing in 2005 again. They must have something like to store the dtsx in prior versions like we have in the word excel etc.

    Thanks anyways.

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

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