Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs s
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules
notifications).
After the package was supposed to have run, I viewed the job histor
and found out that it failed.
is there a way to be able to schedule a package (structured storag
file) from another computer
--
newomog
----
newomoge's Profile: http://www.msusenet.com/member.php?userid=253
View this thread: http://www.msusenet.com/t-187055672Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269074
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.msusenet.com> wrote in message
news:newomoge.1r1e0s@.no-mx.msusenet.com...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> ---
> newomoge's Profile: http://www.msusenet.com/member.php?userid=2530
> View this thread: http://www.msusenet.com/t-1870556724
>sqlsql
Showing posts with label moving. Show all posts
Showing posts with label moving. Show all posts
Tuesday, March 27, 2012
DTS Remote Scheduling
Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
View this thread: http://www.mswebservertalk.com/t-1870556724
Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default...;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.mswebservertalk.com> wrote in message
news:newomoge.1r1e0s@.no-mx.mswebservertalk.com...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
> View this thread: http://www.mswebservertalk.com/t-1870556724
>
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
View this thread: http://www.mswebservertalk.com/t-1870556724
Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default...;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.mswebservertalk.com> wrote in message
news:newomoge.1r1e0s@.no-mx.mswebservertalk.com...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
> View this thread: http://www.mswebservertalk.com/t-1870556724
>
DTS Remote Scheduling
Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
---
newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
View this thread: http://www.msmcse.ms/t-1870556724Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/defaul...b;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.msmcse.ms> wrote in message
news:newomoge.1r1e0s@.no-mx.msmcse.ms...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> ---
> newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
> View this thread: http://www.msmcse.ms/t-1870556724
>
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
---
newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
View this thread: http://www.msmcse.ms/t-1870556724Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/defaul...b;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.msmcse.ms> wrote in message
news:newomoge.1r1e0s@.no-mx.msmcse.ms...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> ---
> newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
> View this thread: http://www.msmcse.ms/t-1870556724
>
Thursday, March 22, 2012
DTS packages on new SQL Server
We're building a new W2K server with the same name as the current one. We
are taking down the old server, moving all the datafiles to the new server,
installing SQL Server, Analysis Services and sp3. The last time we did this
we lost our DTS packages. Can I export them somehow and then import them?
Are they not stored in the system tables?
Thanks,
DougThey are stored in the MSDB database, but moving that database is always
trickey. You can load the DTS packages into Enterprise Mangler and save
them to the file system. You can then reload and resave them when the new
server is ready. If you have a lot of packages, you can write a script to
do that automagically using SQL-DMO and the Package2 object.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
> We're building a new W2K server with the same name as the current one. We
> are taking down the old server, moving all the datafiles to the new
server,
> installing SQL Server, Analysis Services and sp3. The last time we did
this
> we lost our DTS packages. Can I export them somehow and then import them?
> Are they not stored in the system tables?
> Thanks,
> Doug
>|||OK, I saved a package to a .dts file. How do I import/execute that file?
Thanks,
Doug
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
> They are stored in the MSDB database, but moving that database is always
> trickey. You can load the DTS packages into Enterprise Mangler and save
> them to the file system. You can then reload and resave them when the new
> server is ready. If you have a lot of packages, you can write a script
to
> do that automagically using SQL-DMO and the Package2 object.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
We
> server,
> this
them?
>|||I found out how to do this by right clicking on the DTS folder in EM
I should have posted my question in: microsoft.public.sqlserver.tools
"Doug Stiers" <stiers@.email.com> wrote in message
news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
> OK, I saved a package to a .dts file. How do I import/execute that file?
> Thanks,
> Doug
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
new
> to
> We
> them?
>|||Don't worry about it. .Server is pretty much a catch-all anyway.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:uIICb9FDEHA.2908@.TK2MSFTNGP09.phx.gbl...
> I found out how to do this by right clicking on the DTS folder in EM
> I should have posted my question in: microsoft.public.sqlserver.tools
>
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
always
save
> new
script
one.
did
>
are taking down the old server, moving all the datafiles to the new server,
installing SQL Server, Analysis Services and sp3. The last time we did this
we lost our DTS packages. Can I export them somehow and then import them?
Are they not stored in the system tables?
Thanks,
DougThey are stored in the MSDB database, but moving that database is always
trickey. You can load the DTS packages into Enterprise Mangler and save
them to the file system. You can then reload and resave them when the new
server is ready. If you have a lot of packages, you can write a script to
do that automagically using SQL-DMO and the Package2 object.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
> We're building a new W2K server with the same name as the current one. We
> are taking down the old server, moving all the datafiles to the new
server,
> installing SQL Server, Analysis Services and sp3. The last time we did
this
> we lost our DTS packages. Can I export them somehow and then import them?
> Are they not stored in the system tables?
> Thanks,
> Doug
>|||OK, I saved a package to a .dts file. How do I import/execute that file?
Thanks,
Doug
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
> They are stored in the MSDB database, but moving that database is always
> trickey. You can load the DTS packages into Enterprise Mangler and save
> them to the file system. You can then reload and resave them when the new
> server is ready. If you have a lot of packages, you can write a script
to
> do that automagically using SQL-DMO and the Package2 object.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
We
> server,
> this
them?
>|||I found out how to do this by right clicking on the DTS folder in EM
I should have posted my question in: microsoft.public.sqlserver.tools
"Doug Stiers" <stiers@.email.com> wrote in message
news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
> OK, I saved a package to a .dts file. How do I import/execute that file?
> Thanks,
> Doug
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
new
> to
> We
> them?
>|||Don't worry about it. .Server is pretty much a catch-all anyway.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:uIICb9FDEHA.2908@.TK2MSFTNGP09.phx.gbl...
> I found out how to do this by right clicking on the DTS folder in EM
> I should have posted my question in: microsoft.public.sqlserver.tools
>
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
always
save
> new
script
one.
did
>
dts packages
hi
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KPHave a look at
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
hi
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KP|||Hi,
If there are not many packages, you can open them individually and do a
'package| Save as ' pointing to the SQL2000 server.If not, try to transfer
the packages directly between
sysdtspackages(http://www.sqldts.com/main.asp?nav=1,6,204,0)
Also, you can use a tool called ScriptPkg which is present in the SQL Server
setup CD.This tool can script your packages to VB code which can be then
executed against SQL2000.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
> hi
> I have my database & dts packages are on sql 7.0 with
> windows nt4.0. I am moving the database to sql 2000.
> Database part I am quite sure how to proceed. How do I go
> about moving or for that matter to copy the dts packages
> to sql 2000. any help in this regard is appreciated
> thanks
> KP
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KPHave a look at
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
hi
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KP|||Hi,
If there are not many packages, you can open them individually and do a
'package| Save as ' pointing to the SQL2000 server.If not, try to transfer
the packages directly between
sysdtspackages(http://www.sqldts.com/main.asp?nav=1,6,204,0)
Also, you can use a tool called ScriptPkg which is present in the SQL Server
setup CD.This tool can script your packages to VB code which can be then
executed against SQL2000.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
> hi
> I have my database & dts packages are on sql 7.0 with
> windows nt4.0. I am moving the database to sql 2000.
> Database part I am quite sure how to proceed. How do I go
> about moving or for that matter to copy the dts packages
> to sql 2000. any help in this regard is appreciated
> thanks
> KP
Wednesday, March 21, 2012
DTS Packages
I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three step
SQL job that:
1. truncates data
2. runs a DTS package
3. runs a stored procedure
In 2000 I ran DTSRUNUI to generate an encripted command that generated a
GUID line. This was the line in I inserted into step two listed above.
In SQL 2005 I installed the dts compatability stuff but it does not give me
the DTSRUNUI application. Any suggestions other than use SSIS?
Thanks
Titan
Hi
Why don't you run the package using it's name?
John
"Titan" <Titan@.discussions.microsoft.com> wrote in message
news:380EC2B4-133A-4F4A-BA11-2677D1F066DD@.microsoft.com...
> I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three
> step
> SQL job that:
> 1. truncates data
> 2. runs a DTS package
> 3. runs a stored procedure
> In 2000 I ran DTSRUNUI to generate an encripted command that generated a
> GUID line. This was the line in I inserted into step two listed above.
> In SQL 2005 I installed the dts compatability stuff but it does not give
> me
> the DTSRUNUI application. Any suggestions other than use SSIS?
> --
> Thanks
> Titan
SQL job that:
1. truncates data
2. runs a DTS package
3. runs a stored procedure
In 2000 I ran DTSRUNUI to generate an encripted command that generated a
GUID line. This was the line in I inserted into step two listed above.
In SQL 2005 I installed the dts compatability stuff but it does not give me
the DTSRUNUI application. Any suggestions other than use SSIS?
Thanks
Titan
Hi
Why don't you run the package using it's name?
John
"Titan" <Titan@.discussions.microsoft.com> wrote in message
news:380EC2B4-133A-4F4A-BA11-2677D1F066DD@.microsoft.com...
> I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three
> step
> SQL job that:
> 1. truncates data
> 2. runs a DTS package
> 3. runs a stored procedure
> In 2000 I ran DTSRUNUI to generate an encripted command that generated a
> GUID line. This was the line in I inserted into step two listed above.
> In SQL 2005 I installed the dts compatability stuff but it does not give
> me
> the DTSRUNUI application. Any suggestions other than use SSIS?
> --
> Thanks
> Titan
DTS Packages
I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three step
SQL job that:
1. truncates data
2. runs a DTS package
3. runs a stored procedure
In 2000 I ran DTSRUNUI to generate an encripted command that generated a
GUID line. This was the line in I inserted into step two listed above.
In SQL 2005 I installed the dts compatability stuff but it does not give me
the DTSRUNUI application. Any suggestions other than use SSIS?
--
Thanks
TitanHi
Why don't you run the package using it's name?
John
"Titan" <Titan@.discussions.microsoft.com> wrote in message
news:380EC2B4-133A-4F4A-BA11-2677D1F066DD@.microsoft.com...
> I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three
> step
> SQL job that:
> 1. truncates data
> 2. runs a DTS package
> 3. runs a stored procedure
> In 2000 I ran DTSRUNUI to generate an encripted command that generated a
> GUID line. This was the line in I inserted into step two listed above.
> In SQL 2005 I installed the dts compatability stuff but it does not give
> me
> the DTSRUNUI application. Any suggestions other than use SSIS?
> --
> Thanks
> Titansqlsql
SQL job that:
1. truncates data
2. runs a DTS package
3. runs a stored procedure
In 2000 I ran DTSRUNUI to generate an encripted command that generated a
GUID line. This was the line in I inserted into step two listed above.
In SQL 2005 I installed the dts compatability stuff but it does not give me
the DTSRUNUI application. Any suggestions other than use SSIS?
--
Thanks
TitanHi
Why don't you run the package using it's name?
John
"Titan" <Titan@.discussions.microsoft.com> wrote in message
news:380EC2B4-133A-4F4A-BA11-2677D1F066DD@.microsoft.com...
> I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three
> step
> SQL job that:
> 1. truncates data
> 2. runs a DTS package
> 3. runs a stored procedure
> In 2000 I ran DTSRUNUI to generate an encripted command that generated a
> GUID line. This was the line in I inserted into step two listed above.
> In SQL 2005 I installed the dts compatability stuff but it does not give
> me
> the DTSRUNUI application. Any suggestions other than use SSIS?
> --
> Thanks
> Titansqlsql
Subscribe to:
Posts (Atom)