dbTalk Databases Forums  

Scheduling a DTS package in SQL 2005..

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Scheduling a DTS package in SQL 2005..

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Scheduling a DTS package in SQL 2005.. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roz
 
Posts: n/a

Default Scheduling a DTS package in SQL 2005.. - 02-04-2006 , 02:22 PM





Hello all. I imported (not migrated) a few SQL 2000 DTS packages into SQL
2005. Of course, they appear under the Management...Legacy tree. I can't
seem to figure out how to schedule these packages using SQL Agent. Migrating
the packages to native SQL 2005 isn't an option, because I lost my column
mappings once these packages are truly migrated.

Any pointers, suggestions, etc.

Thanks
Roz


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Scheduling a DTS package in SQL 2005.. - 02-04-2006 , 03:32 PM





Hello Roz,

Because you installed the DTSRuntime support when you installed SSIS you
can call in a job DTSRun as per 2000.


Allan


Quote:
Hello all. I imported (not migrated) a few SQL 2000 DTS packages into
SQL 2005. Of course, they appear under the Management...Legacy tree.
I can't seem to figure out how to schedule these packages using SQL
Agent. Migrating the packages to native SQL 2005 isn't an option,
because I lost my column mappings once these packages are truly
migrated.

Any pointers, suggestions, etc.

Thanks Roz



Reply With Quote
  #3  
Old   
Roz
 
Posts: n/a

Default Re: Scheduling a DTS package in SQL 2005.. - 02-04-2006 , 06:03 PM


Excellent Allan. I'll give it a try.

Thanks again,

Roz


"Allan Mitchell" wrote:

Quote:
Hello Roz,

Because you installed the DTSRuntime support when you installed SSIS you
can call in a job DTSRun as per 2000.


Allan


Hello all. I imported (not migrated) a few SQL 2000 DTS packages into
SQL 2005. Of course, they appear under the Management...Legacy tree.
I can't seem to figure out how to schedule these packages using SQL
Agent. Migrating the packages to native SQL 2005 isn't an option,
because I lost my column mappings once these packages are truly
migrated.

Any pointers, suggestions, etc.

Thanks Roz

Reply With Quote
  #4  
Old   
Roz
 
Posts: n/a

Default Re: Scheduling a DTS package in SQL 2005.. - 02-08-2006 , 02:04 PM


Allan,

I tried to schedule my 2000 DTS package with SQL 2005. I tried to find help
on the DTSRun command, but no luck. Very strange no doc was there for it,
only for "DtsRuntimeException class". Weird. In SQL 2000, I could
right-click on a dts package, and "Schedule...." would be an option. In
2005, I have to schdule it under SQL Agent...Jobs (which is OK), but still
can't find help on the DTSRun command.

I know one of the parameters the DTSRun takes is the package id, where can I
get this information for my legacy packages?

Thanks again.

Roz


"Allan Mitchell" wrote:

Quote:
Hello Roz,

Because you installed the DTSRuntime support when you installed SSIS you
can call in a job DTSRun as per 2000.


Allan


Hello all. I imported (not migrated) a few SQL 2000 DTS packages into
SQL 2005. Of course, they appear under the Management...Legacy tree.
I can't seem to figure out how to schedule these packages using SQL
Agent. Migrating the packages to native SQL 2005 isn't an option,
because I lost my column mappings once these packages are truly
migrated.

Any pointers, suggestions, etc.

Thanks Roz

Reply With Quote
  #5  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Scheduling a DTS package in SQL 2005.. - 02-08-2006 , 02:12 PM


Hello Roz,

Here you go

http://msdn.microsoft.com/library/de...tsrun_95kp.asp


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:
Allan,

I tried to schedule my 2000 DTS package with SQL 2005. I tried to
find help on the DTSRun command, but no luck. Very strange no doc was
there for it, only for "DtsRuntimeException class". Weird. In SQL
2000, I could right-click on a dts package, and "Schedule...." would
be an option. In 2005, I have to schdule it under SQL Agent...Jobs
(which is OK), but still can't find help on the DTSRun command.

I know one of the parameters the DTSRun takes is the package id, where
can I get this information for my legacy packages?

Thanks again.

Roz

"Allan Mitchell" wrote:

Hello Roz,

Because you installed the DTSRuntime support when you installed SSIS
you can call in a job DTSRun as per 2000.

Allan

Hello all. I imported (not migrated) a few SQL 2000 DTS packages
into SQL 2005. Of course, they appear under the Management...Legacy
tree. I can't seem to figure out how to schedule these packages
using SQL Agent. Migrating the packages to native SQL 2005 isn't an
option, because I lost my column mappings once these packages are
truly migrated.

Any pointers, suggestions, etc.

Thanks Roz



Reply With Quote
  #6  
Old   
Roz
 
Posts: n/a

Default Re: Scheduling a DTS package in SQL 2005.. - 02-08-2006 , 02:30 PM


Thanks. Any reason why this isn't in the SQL 2005 books online?

"Allan Mitchell" wrote:

Quote:
Hello Roz,

Here you go

http://msdn.microsoft.com/library/de...tsrun_95kp.asp


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Allan,

I tried to schedule my 2000 DTS package with SQL 2005. I tried to
find help on the DTSRun command, but no luck. Very strange no doc was
there for it, only for "DtsRuntimeException class". Weird. In SQL
2000, I could right-click on a dts package, and "Schedule...." would
be an option. In 2005, I have to schdule it under SQL Agent...Jobs
(which is OK), but still can't find help on the DTSRun command.

I know one of the parameters the DTSRun takes is the package id, where
can I get this information for my legacy packages?

Thanks again.

Roz

"Allan Mitchell" wrote:

Hello Roz,

Because you installed the DTSRuntime support when you installed SSIS
you can call in a job DTSRun as per 2000.

Allan

Hello all. I imported (not migrated) a few SQL 2000 DTS packages
into SQL 2005. Of course, they appear under the Management...Legacy
tree. I can't seem to figure out how to schedule these packages
using SQL Agent. Migrating the packages to native SQL 2005 isn't an
option, because I lost my column mappings once these packages are
truly migrated.

Any pointers, suggestions, etc.

Thanks Roz

Reply With Quote
  #7  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Scheduling a DTS package in SQL 2005.. - 02-08-2006 , 02:34 PM


Hello Roz,

Because it isn't part of 2K5. DTExec is the 2K5 version

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:
Thanks. Any reason why this isn't in the SQL 2005 books online?

"Allan Mitchell" wrote:

Hello Roz,

Here you go

http://msdn.microsoft.com/library/de...ary/en-us/copr
ompt/cp_dtsrun_95kp.asp

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
Allan,

I tried to schedule my 2000 DTS package with SQL 2005. I tried to
find help on the DTSRun command, but no luck. Very strange no doc
was there for it, only for "DtsRuntimeException class". Weird. In
SQL 2000, I could right-click on a dts package, and "Schedule...."
would be an option. In 2005, I have to schdule it under SQL
Agent...Jobs (which is OK), but still can't find help on the DTSRun
command.

I know one of the parameters the DTSRun takes is the package id,
where can I get this information for my legacy packages?

Thanks again.

Roz

"Allan Mitchell" wrote:

Hello Roz,

Because you installed the DTSRuntime support when you installed
SSIS you can call in a job DTSRun as per 2000.

Allan

Hello all. I imported (not migrated) a few SQL 2000 DTS packages
into SQL 2005. Of course, they appear under the
Management...Legacy tree. I can't seem to figure out how to
schedule these packages using SQL Agent. Migrating the packages
to native SQL 2005 isn't an option, because I lost my column
mappings once these packages are truly migrated.

Any pointers, suggestions, etc.

Thanks Roz



Reply With Quote
  #8  
Old   
Roz
 
Posts: n/a

Default Re: Scheduling a DTS package in SQL 2005.. - 02-08-2006 , 02:41 PM


Thanks.

"Allan Mitchell" wrote:

Quote:
Hello Roz,

Because it isn't part of 2K5. DTExec is the 2K5 version

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanks. Any reason why this isn't in the SQL 2005 books online?

"Allan Mitchell" wrote:

Hello Roz,

Here you go

http://msdn.microsoft.com/library/de...ary/en-us/copr
ompt/cp_dtsrun_95kp.asp

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
Allan,

I tried to schedule my 2000 DTS package with SQL 2005. I tried to
find help on the DTSRun command, but no luck. Very strange no doc
was there for it, only for "DtsRuntimeException class". Weird. In
SQL 2000, I could right-click on a dts package, and "Schedule...."
would be an option. In 2005, I have to schdule it under SQL
Agent...Jobs (which is OK), but still can't find help on the DTSRun
command.

I know one of the parameters the DTSRun takes is the package id,
where can I get this information for my legacy packages?

Thanks again.

Roz

"Allan Mitchell" wrote:

Hello Roz,

Because you installed the DTSRuntime support when you installed
SSIS you can call in a job DTSRun as per 2000.

Allan

Hello all. I imported (not migrated) a few SQL 2000 DTS packages
into SQL 2005. Of course, they appear under the
Management...Legacy tree. I can't seem to figure out how to
schedule these packages using SQL Agent. Migrating the packages
to native SQL 2005 isn't an option, because I lost my column
mappings once these packages are truly migrated.

Any pointers, suggestions, etc.

Thanks Roz

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top