not registered for use on this computer

Question

Post reply

not registered for use on this computer

AAAV

SSC Veteran

Points: 287
More actions
April 14, 2010 at 1:11 pm

#217871

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?

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

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

TAMMYAUDETTE Ten Centuries Points: 1259 More actions · Answer 1

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.

AAAV SSC Veteran Points: 287 More actions · Answer 2

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

Phil Parkin SSC Guru Points: 246965 More actions · Answer 3

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

AAAV SSC Veteran Points: 287 More actions · Answer 4

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.