DTS problem\bug

We have a server W2k\SQL2k in which we are able to open a DTS designer, save
the package, but on refresh the DTS package is not listed. We rebooted the
server, and run set of DBCC’s which all came clean. Did anyone experience
similar issue?
Hi
I have not seen this behavour before and it's not listed on
http://www.sqldts.com/default.aspx?106
Are you saving the package into the database? If you save it into a
structured file, what happens if you try to import it and save it into the
database?
If this package is being imported from elsewhere, are you at the same
service pack and MDAC levels?
If all that fails you may want to run profiler to see that the package gets
inserted into msdb.
John
"MikeS" <MikeS@.discussions.microsoft.com> wrote in message
news:E60E3786-0D0D-4FA8-B169-4C8918C5DBED@.microsoft.com...
> We have a server W2k\SQL2k in which we are able to open a DTS designer,
save
> the package, but on refresh the DTS package is not listed. We rebooted the
> server, and run set of DBCC's which all came clean. Did anyone experience
> similar issue?

DTS problem\bug

We have a server W2k\SQL2k in which we are able to open a DTS designer, save
the package, but on refresh the DTS package is not listed. We rebooted the
server, and run set of DBCCâ's which all came clean. Did anyone experience
similar issue?Hi
I have not seen this behavour before and it's not listed on
http://www.sqldts.com/default.aspx?106
Are you saving the package into the database? If you save it into a
structured file, what happens if you try to import it and save it into the
database?
If this package is being imported from elsewhere, are you at the same
service pack and MDAC levels?
If all that fails you may want to run profiler to see that the package gets
inserted into msdb.
John
"MikeS" <MikeS@.discussions.microsoft.com> wrote in message
news:E60E3786-0D0D-4FA8-B169-4C8918C5DBED@.microsoft.com...
> We have a server W2k\SQL2k in which we are able to open a DTS designer,
save
> the package, but on refresh the DTS package is not listed. We rebooted the
> server, and run set of DBCC's which all came clean. Did anyone experience
> similar issue?

DTS problem\bug

We have a server W2k\SQL2k in which we are able to open a DTS designer, save
the package, but on refresh the DTS package is not listed. We rebooted the
server, and run set of DBCC’s which all came clean. Did anyone experience
similar issue?Hi
I have not seen this behavour before and it's not listed on
http://www.sqldts.com/default.aspx?106
Are you saving the package into the database? If you save it into a
structured file, what happens if you try to import it and save it into the
database?
If this package is being imported from elsewhere, are you at the same
service pack and MDAC levels?
If all that fails you may want to run profiler to see that the package gets
inserted into msdb.
John
"MikeS" <MikeS@.discussions.microsoft.com> wrote in message
news:E60E3786-0D0D-4FA8-B169-4C8918C5DBED@.microsoft.com...
> We have a server W2k\SQL2k in which we are able to open a DTS designer,
save
> the package, but on refresh the DTS package is not listed. We rebooted the
> server, and run set of DBCC's which all came clean. Did anyone experience
> similar issue?sqlsql

DTS launch from SQL Server Agent

Hi,

I want to build a task that does 3 things automatically at a fixed time interval:

1) Refresh the data (copy newly inserted data from a datamart to a datawarehouse)
2) Run a program (exe) to produce some external reports
3) Refresh an OLAP Cube with the new data so that users can access it

Basically, using SQL Server Agent, setting up steps 1 and 2 was pretty straightforward (for step 1, the main point of entry is a single sp).

I ran into some trouble figuring the easiest way to complete step 3. I created a DTS package with one object that updates the Cude on my server. This seems to be working fine. Then, I created step 3 in Agent and chose 'CmdExec' as the type of command. I then referenced the external exe 'dtsrun' to execute my DTS package.

Everything seems fine but I'm not sure I used the "best" way of doing things. Since the SQL Server Agent and DTS manager are both SQL Server tools (so is the Analysis services), I'm wondering if there wasn't an easier (thus more robust) way of completing my 3rd step?

Anyone? How is this done where you've worked?

Thanks,

Skip.Well, that is the technique that MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_dts_pkgmng_9vck.asp) suggests.

You could always make the DTS Package into a SQL Agent job (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_dts_pkgmng_71v2.asp), then run the job using sp_start_job (http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_sa-sz_11uq.asp) (but that is deviant).

-PatP|||As always I suggest this kBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to help DTS to schedule as a job.

DTS Help

Hi,
Right off the bat, I am brand new to using DTS.
Using Enterprise Manager 8.0
I have a production db and a test db. I want to refresh several test
tables for testing. I've written a package that gets each table from
source and writes to destination, no problem. But I have 7 tables to
refresh in order, via primary key, so I have 7 "Transform Data Tasks", I
have to scramble some data columns during the refresh.
Now that I have these working I want to know how to run them in order,
without me hitting the "Execute Step" menu option myself.
Thank you in advance
Eric
You can use workflows to control the order of the tasks. Set
the workflows so that upon completion of task 1, task 2 will
execute, upon completion of task 2, task 3 will execute,
etc. You can take a look at some of the workflow examples at
the following site - that should give you an idea of how to
start setting up your package for order of execution of
tasks:
http://www.sqldts.com/103.aspx
-Sue
On Thu, 22 Mar 2007 12:23:40 -0700, eric <poster@.cox.net>
wrote:

>Hi,
> Right off the bat, I am brand new to using DTS.
>Using Enterprise Manager 8.0
> I have a production db and a test db. I want to refresh several test
>tables for testing. I've written a package that gets each table from
>source and writes to destination, no problem. But I have 7 tables to
>refresh in order, via primary key, so I have 7 "Transform Data Tasks", I
>have to scramble some data columns during the refresh.
> Now that I have these working I want to know how to run them in order,
>without me hitting the "Execute Step" menu option myself.
> Thank you in advance
> Eric
|||Sue,
Thank you so much for the help.
Eric
Sue Hoegemeier wrote:
> You can use workflows to control the order of the tasks. Set
> the workflows so that upon completion of task 1, task 2 will
> execute, upon completion of task 2, task 3 will execute,
> etc. You can take a look at some of the workflow examples at
> the following site - that should give you an idea of how to
> start setting up your package for order of execution of
> tasks:
> http://www.sqldts.com/103.aspx
> -Sue
> On Thu, 22 Mar 2007 12:23:40 -0700, eric <poster@.cox.net>
> wrote:
>
>