Hello all!

I've created a custom DTS task in the .NET Framework 1.1 and have it
installed and partially working on the server it will be residing on. If I
log into the machine using my account and manually open and run the package,
everything works. If I log in and use the limited SQL Server account, the
task will not show up when creating a new package, the saved package opens
with a "Invalid Class String" and trying to run the task gives the same
thing.

I think it is something to do with the .NET Framework and rights as I have
other tasks I've written in other languages that work fine with that
account.

Anybody have a clue what I need to modify to get it to work?

Scott

Looks like the install package I built will not work for DTS Tasks. I
uninstalled the installed package and then copied everything over to the
server and manually registered all the components and now it is working for
both IDs. So much for an automated install routine.

Scott

"Wm. Scott Miller" <Scott.Miller (AT) spamkillerwvinsurance (DOT) gov> wrote

Sounds like you installed some of the task registry settings under a user
specific account, as opposed to an all user or machine level root.

Checkout the "Registering a DTS Custom Task" topic in Books Online, and also
have a look at what is there already.

--
Darren Green
http://www.sqldts.com

"Wm. Scott Miller" <Scott.Miller (AT) spamkillerwvinsurance (DOT) gov> wrote

Darren:

Yeah, I tried using VS.NET 2003 installation project. Haven't had much luck
with it and it won't allow me to choose to have the DLL self-register.
Problematic to say the least. Have you had any luck using VS.NET to build a
custom task and then build an installation package for it? If you have
success, might want to post that to your website. Probably get alot of
kudos from it......:-)

BTW, great website. Keep up the good work. I've used it many times to get
out of a bind and I recommend it to all my friends that are now asking me
questions about DTS and how to get it to [fill in the blank].

Scott

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

In message <OiAhCpR6EHA.3700 (AT) tk2msftngp13 (DOT) phx.gbl>, Wm. Scott Miller
<Scott.Miller (AT) spamkillerwvinsurance (DOT) gov> writes
I've only ever done it in VSI from VS6. Self register followed by a load
of manual reg entries. Seemed to work OK though.

For .Net use the "DLLRegister" functions or whatever they are called,
the ones that you implement in the class itself.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I'll have to look around a VS.NET installation project and see what I can
find. It is totally different to any other installation builder I've used
to date. Would be nice if there was a simple check box for "Run regasm on
this file" or "Run gacutil on this file" since those would be rather regular
and normal tasks (esp. with a custom task install anyway). The only way
I've found to get a file added to the GAC is to have it copied directly to
the GAC in the install. And the Self Registration option doesn't work and
the regular COM options only put in the entries that you don't implement in
code.

Have a Merry Christmas and eat way too much!

Scott

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

The GAC is a special folder that you can add under the file system area of
teh isntaller project.

Do the registrion in the class as opposed to teh installer.


--
Darren Green
http://www.sqldts.com

"Wm. Scott Miller" <Scott.Miller (AT) spamkillerwvinsurance (DOT) gov> wrote