|
Home > Archive > MS SQL Server DTS > March 2006 > Sharing code between DTS packages.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sharing code between DTS packages.
|
|
| John Peterson 2006-03-29, 3:28 am |
| (SQL Server 2000, SP3a)
Hello all!
I've been trying to figure out whether DTS will allow for "shared" code.
That is, I have a DTS package that has a file logging system. I'd like to
somehow leverage that code inside of other DTS packages -- sort of like an
"include" file, if you will.
From everything that I've seen, it would appear that DTS doesn't handle that
kind of re-use very easily. If anyone has any suggestions, I'd be greatly
obliged! :-)
| |
| Helmut Rieder 2006-03-29, 7:31 am |
| Hello,
I doesn't know a way to share code between DTS packages, but there are many
possibilities to share code with some tricks.
If you would share "Active-X Code" maybe you could extract this code to an
external script like Windows Scripting Host, VB, Perl or anything else and
run this script in the different DTS package.
If you mean Transact SQL Code you could create a stored procedure and run
the procedure from the DTS package.
There are still other ways, but this are the simplest ones.
Greetings
Helmut Rieder
"John Peterson" wrote:
> (SQL Server 2000, SP3a)
>
> Hello all!
>
> I've been trying to figure out whether DTS will allow for "shared" code.
> That is, I have a DTS package that has a file logging system. I'd like to
> somehow leverage that code inside of other DTS packages -- sort of like an
> "include" file, if you will.
>
> From everything that I've seen, it would appear that DTS doesn't handle that
> kind of re-use very easily. If anyone has any suggestions, I'd be greatly
> obliged! :-)
>
>
>
| |
| John Peterson 2006-03-29, 8:27 pm |
| Thanks Helmut! Yeah, I'd be eager to learn how to potentially share ActiveX
code so that I don't have to have the same function in every package that
I'm using.
"Helmut Rieder" <Helmut Rieder@discussions.microsoft.com> wrote in message
news:3AC273A2-C595-47A5-AB1E- 942B9E6ADD20@microso
ft.com...[color=darkred]
> Hello,
>
> I doesn't know a way to share code between DTS packages, but there are
> many
> possibilities to share code with some tricks.
>
> If you would share "Active-X Code" maybe you could extract this code to an
> external script like Windows Scripting Host, VB, Perl or anything else and
> run this script in the different DTS package.
>
> If you mean Transact SQL Code you could create a stored procedure and run
> the procedure from the DTS package.
>
> There are still other ways, but this are the simplest ones.
>
> Greetings
>
> Helmut Rieder
>
> "John Peterson" wrote:
>
|
|
|
|
|