Home > SQL Server > Error: The task with the name Data Flow Task and the creation name “DTS.Pipeline.1” is not registered for use on this computer

Error: The task with the name Data Flow Task and the creation name “DTS.Pipeline.1” is not registered for use on this computer


I also ever experienced this problem. 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.

finally, i found out how to solve this problem…
thanks to sulton..

Advertisements
Categories: SQL Server
  1. sameerbaig0@gmail.com
    September 9, 2014 at 7:23 am

    Thanks for giving the solution

    • yasserzaid
      September 17, 2014 at 9:09 am

      @sameerbaig0 : You are welcome

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: