Very Computer

Excuse me if this is a real lamer ....

My DTS package has gotten sufficiency complex that I am finding editing the
code, and particularly debugging the code *very* inefficient using the
Enterprise manager interface.

Is there any way that I can export my packages into a Vis Studio so that I
can continue to build them there? Or is there a 'proper de*' that I can
use (i.e setting breakpoints  and tracking variable values) with EM?

rgds

tom

Hi Tom,

I think you can save the package into a Visual Basic file. In Package
Designer, select Package | Save As, select "Visual Basic File" for Location.

This posting is provided "AS IS" with no warranties, and confers no rights.

Regards,

Bill Cheng
Microsoft Support Engineer
--------------------

| Subject: Debug / export dts packages
| Date: Thu, 22 May 2003 19:20:25 +0100
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000

| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: host81-134-7-78.in-addr.btopenworld.com 81.134.7.78
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:33994
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Excuse me if this is a real lamer ....
|
| My DTS package has gotten sufficiency complex that I am finding editing
the
| code, and particularly debugging the code *very* inefficient using the
| Enterprise manager interface.
|
| Is there any way that I can export my packages into a Vis Studio so that I
| can continue to build them there? Or is there a 'proper de*' that I
can
| use (i.e setting breakpoints  and tracking variable values) with EM?
|
| rgds
|
| tom
|
|
|
|
|

Hi Tdj,
Here is an article in How To Install DTS Event Handlers In Visual Basic
http://www.veryComputer.com/;EN-US;Q221193
JFB

Quote:> Excuse me if this is a real lamer ....

> My DTS package has gotten sufficiency complex that I am finding editing
the
> code, and particularly debugging the code *very* inefficient using the
> Enterprise manager interface.

> Is there any way that I can export my packages into a Vis Studio so that I
> can continue to build them there? Or is there a 'proper de*' that I
can
> use (i.e setting breakpoints  and tracking variable values) with EM?

> rgds

> tom

Bill, JFB,

Ok,

I can see the answer to someone of my ability is: No there is no easy way.

I did export to vb and then opened in Vis Studio but could not get the
packages to run ( I have three with a parent, child grandchild relationship)
I suspect that it could work but that would require some messing with a test
project, some thing I don't have time for right now.

Thanks anyway

tom

Hi Tom,

I suggest that you check with a very simple DTS package Visual Basic code
first. The problem with the package may be that it is too complex to
troubleshoot easily. A simple package to test would be better to start with.

This posting is provided "AS IS" with no warranties, and confers no rights.

Regards,

Bill Cheng
Microsoft Support Engineer
--------------------



| Subject: Re: Debug / export dts packages
| Date: Fri, 23 May 2003 14:35:33 +0100
| Lines: 50
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000

| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: host81-134-22-64.in-addr.btopenworld.com 81.134.22.64
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:34014
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Bill, JFB,
|
|
| Ok,
|
| I can see the answer to someone of my ability is: No there is no easy way.
|
| I did export to vb and then opened in Vis Studio but could not get the
| packages to run ( I have three with a parent, child grandchild
relationship)
| I suspect that it could work but that would require some messing with a
test
| project, some thing I don't have time for right now.
|
| Thanks anyway
|
| tom
|
|

| > Hi Tdj,
| > Here is an article in How To Install DTS Event Handlers In Visual Basic
| > http://www.veryComputer.com/;EN-US;Q221193
| > JFB
| >


| > > Excuse me if this is a real lamer ....
| > >
| > > My DTS package has gotten sufficiency complex that I am finding
editing
| > the
| > > code, and particularly debugging the code *very* inefficient using the
| > > Enterprise manager interface.
| > >
| > > Is there any way that I can export my packages into a Vis Studio so
that
| I
| > > can continue to build them there? Or is there a 'proper de*'
that I
| > can
| > > use (i.e setting breakpoints  and tracking variable values) with EM?
| > >
| > > rgds
| > >
| > > tom
| > >
| > >
| > >
| > >
| >
| >
|
|
|

Quote:>Bill, JFB,

>Ok,

>I can see the answer to someone of my ability is: No there is no easy way.

>I did export to vb and then opened in Vis Studio but could not get the
>packages to run ( I have three with a parent, child grandchild relationship)
>I suspect that it could work but that would require some messing with a test
>project, some thing I don't have time for right now.

>Thanks anyway

>tom

First off you need to add the references to the DTS libraries, of which
there will be three in SQL 2000, depending what tasks are used.

One problem with the Save AS VB is that on a large package it can
produce a file that is not compatible with VB, too big basically.

You can use the VS IDE de* to debug ActiveX Scripts, but it still
isn't great.

You got the short answer correct above.
--
Darren Green (SQL Server MVP)
DTS - http://www.veryComputer.com/