No.  From BOL:

KILL permissions default to the members of the sysadmin and processadmin fixed database roles, and are not transferable.

"Not transferable" means you can't assign the permission...

I agree with Juliekenny.  Import the csv file into a staging table then use an UPDATE statement to join the staging table to tb_users and update the role column.

Greg

You didn't answer Allen's question about whether you can execute the DTS package manually.  From the message you posted, I think the problem is in the package, not the job. ...

Interesting.  We've been discussing the idea of putting our dev and demo on a single box in two instances. 

We haven't examined all the pros and cons yet but a couple of advantages...

DTS packages in scheduled jobs often fail because of security.  A package in a job executes using the security context of the login that SQL Server Agent run under.  I...

Ah, thanks Steve.  You've gotten me thinking about my once and future favorite car: 1969 Chev Camaro RS/SS with 350, 4 sp, and cowl induction. 

I had one when I...

1. Open the package in DTS Designer

2. Right-click in white space and select 'Package Properties'

3. Select the 'Logging' tab and check the box for 'Log package execution to

    SQL Server'; make...

I work for a state government agency and the IT division has a set budget for a 2 year budget period.  All training requests are prioritized by division management money...

Hi Miguel,

SQLDTS.com has an article about conditional branching in a DTS package.  I've used a version of the technique described in the article and was able to branch based on...

Hi Greg,

Our warehouse uses DTS for ETL and we've been pretty happy with it.  We decided on it because we were already spending a hefty amount on business intelligence and...

Hi Steve,

Glad that helped.  Would you share the solution in case someone else has the same problem?

Thanks,

Greg

Glad to help.  I can't even think how many times logging has helped me figure out a problem in a package.

Greg

Finding what tables and views contain a column is pretty straightforward using system tables:

select o.name,o.xtype from syscolumns c join sysobjects o

       on c.id = o.id

where c.name = 'column x'

Danny,

What permissions did you give the aspnet account in the source database?  Does the account have permission to write to the disk location where the destination file is to be...

Thanks Phill.  I didn't remember that, but our packages are modified manually so I've never had a problem with it.

Thanks again,

Greg