2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike Hayes
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A
|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready".
It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody
knows.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can downloa
d,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready". It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody knows.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Merge Agent Degradation

I have a merge agent running extremely slow - schedule fires every 1 minute,
however it takes 1 to 3 minutes to execute. Delivery Rate 5 rows/sec or less,
all 5 other merge agents execute in less than 20 seconds and Delivery Rate 80
rows/sec or greater.
Each time merge agent fires, subscr cpu spikes to 85% - normally 15 to 20%.
Ran profiler and discovered this stamement below hogging the cpu and having
the longest duration.
I am rebuilding the MSmerge_genhistory table nightly w/ the following: DBCC
DBREINDEX (MSmerge_genhistory, '', 80)
Any ideas? A re-init will resolve problem , have had to do this many times
in past - at least every 30 days... however, want to get to root cause. tia
Chris
select top (@.numgens) *
from
(
select generation, guidsrc, art_nick,
case when genstatus = 4 then 0 else genstatus end as
genstatus,
pubid, nicknames,
okaytoskip = case when
art_nick is not null and art_nick <> 0
and genstatus in (0,4)
-- Skip all rows that are for incomplete
generations for articles that have no joins.
and not exists (select 1 from
dbo.sysmergesubsetfilters where (join_nickname = art_nick or art_nickname =
art_nick) and (filter_type & 1) = 1)
then 1 else 0 end
, changecount
from
(select generation, guidsrc, art_nick, genstatus, pubid,
nicknames, changecount
from dbo.MSmerge_genhistory with (rowlock, repeatableread)
where generation >= @.genstart
and generation <= @.maxgen_to_enumerate
and generation > @.mingen_to_enumerate
and (art_nick = 0 or art_nick is NULL or
art_nick in (select nickname from dbo.sysmergearticles
where pubid = @.pubid))
) as generation_range
UNION ALL -- use UNION ALL instead of UNION for perf
reasons. Merge agent code will skip dupes. Will only have max 2 dupes.
select generation = @.next_possible_watermark, guidsrc =
@.next_possible_watermark_guidsrc,
art_nick = @.next_possible_watermark_art_nick, genstatus =
@.next_possible_watermark_genstatus,
pubid = @.next_possible_watermark_pubid, nicknames =
@.next_possible_watermark_nicknames,
okaytoskip = 0, changecount =
@.next_possible_watermark_changecount
where @.next_possible_watermark is not null
union all
select generation = @.min_open_gen, guidsrc= @.min_open_gen_guid,
art_nick=@.min_open_gen_art_nick, genstatus=0,
pubid=@.pubid, nicknames=NULL, okaytoskip = 0,
changecount=0
where @.min_open_gen is not null
) as genertions
order by generation ASC
Two things I can suggest here is:
1. Avoid metadata contention. Make sure merge agents do not run at the
same time so stagger their schedules.
2. Retention period can cause lots of data to be stored in the contets
and tombstone tables. Default i think is 14 days. So 14 days worth of
changes are stored. Consider reducing this if subscribers are not
offline for a long time.
Regards Jim
http://jims-spanakopita.blogspot.com/
|||What do your join filters look like? By placing indexes on all the filters
you will get better performance. Another option to try is to modify your
filters to make them as shallow as possible.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4ED9E8B8-9CA1-4B10-A609-E67921202C68@.microsoft.com...
> I have a merge agent running extremely slow - schedule fires every 1
> minute,
> however it takes 1 to 3 minutes to execute. Delivery Rate 5 rows/sec or
> less,
> all 5 other merge agents execute in less than 20 seconds and Delivery Rate
> 80
> rows/sec or greater.
> Each time merge agent fires, subscr cpu spikes to 85% - normally 15 to
> 20%.
> Ran profiler and discovered this stamement below hogging the cpu and
> having
> the longest duration.
> I am rebuilding the MSmerge_genhistory table nightly w/ the following:
> DBCC
> DBREINDEX (MSmerge_genhistory, '', 80)
>
> Any ideas? A re-init will resolve problem , have had to do this many times
> in past - at least every 30 days... however, want to get to root cause.
> tia
> Chris
>
> select top (@.numgens) *
> from
> (
> select generation, guidsrc, art_nick,
> case when genstatus = 4 then 0 else genstatus end as
> genstatus,
> pubid, nicknames,
> okaytoskip = case when
> art_nick is not null and art_nick <> 0
> and genstatus in (0,4)
> -- Skip all rows that are for incomplete
> generations for articles that have no joins.
> and not exists (select 1 from
> dbo.sysmergesubsetfilters where (join_nickname = art_nick or art_nickname
> =
> art_nick) and (filter_type & 1) = 1)
> then 1 else 0 end
> , changecount
> from
> (select generation, guidsrc, art_nick, genstatus, pubid,
> nicknames, changecount
> from dbo.MSmerge_genhistory with (rowlock, repeatableread)
> where generation >= @.genstart
> and generation <= @.maxgen_to_enumerate
> and generation > @.mingen_to_enumerate
> and (art_nick = 0 or art_nick is NULL or
> art_nick in (select nickname from dbo.sysmergearticles
> where pubid = @.pubid))
> ) as generation_range
> UNION ALL -- use UNION ALL instead of UNION for perf
> reasons. Merge agent code will skip dupes. Will only have max 2 dupes.
> select generation = @.next_possible_watermark, guidsrc =
> @.next_possible_watermark_guidsrc,
> art_nick = @.next_possible_watermark_art_nick, genstatus =
> @.next_possible_watermark_genstatus,
> pubid = @.next_possible_watermark_pubid, nicknames =
> @.next_possible_watermark_nicknames,
> okaytoskip = 0, changecount =
> @.next_possible_watermark_changecount
> where @.next_possible_watermark is not null
> union all
> select generation = @.min_open_gen, guidsrc= @.min_open_gen_guid,
> art_nick=@.min_open_gen_art_nick, genstatus=0,
> pubid=@.pubid, nicknames=NULL, okaytoskip = 0,
> changecount=0
> where @.min_open_gen is not null
> ) as genertions
> order by generation ASC
>

2005 dts package question

Hi I am working with the trial ms2005 SQL Server measurement studio. I could
not find how to create and schedule a DTS package, guess this is done with
Enterprise Manager with mssql2000. JUst wondering if someone could point me
in the right direction, thanks.
Paul G
Software engineer.
SQL Server Integration Services (SSIS) is the replacement
for DTS in SQL Server 2005. You create SSIS packages using
the Business Intelligence Development Studio. That's where
you find the designer you are used to in 2000.
To schedule the package, create a job and for the step type,
use SQL Server Integration Services Package.
There are How To help topics in books online that give step
by step instructions on how to do this.
For creating packages, refer to:
How To: Create a Package Using SSIS Designer
For scheduling as a job, refer to:
How To: Run a Package Using a SQL Server Agent Job
There are many other How To topics for SSIS. Open up books
online and you will see a How Do I button on the tool bar.
Select that and chose SQL Server Integration Services.
There is also a decent tutorial on using SSIS. From the help
contents, go to SQL Server Tutorials node. Select
Integration Services Tutorials.
You can also find information on SSIS at:
http://www.sqlis.com/
-Sue
On Fri, 17 Mar 2006 12:45:27 -0800, Paul
<Paul@.discussions.microsoft.com> wrote:

>Hi I am working with the trial ms2005 SQL Server measurement studio. I could
>not find how to create and schedule a DTS package, guess this is done with
>Enterprise Manager with mssql2000. JUst wondering if someone could point me
>in the right direction, thanks.
|||they destroyed DTS. and replaced it with a very complicated software called
Integration Services.
Just so you know, you had 4 steps to create an import from a text file. now
you will have no less than 12 steps to do the same. It sucks but what
there's nothing we can do about it.
d.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> Hi I am working with the trial ms2005 SQL Server measurement studio. I
could
> not find how to create and schedule a DTS package, guess this is done with
> Enterprise Manager with mssql2000. JUst wondering if someone could point
me
> in the right direction, thanks.
> --
> Paul G
> Software engineer.
|||Ok thanks for the information, will take a look at it.
Paul G
Software engineer.
"Sue Hoegemeier" wrote:

> SQL Server Integration Services (SSIS) is the replacement
> for DTS in SQL Server 2005. You create SSIS packages using
> the Business Intelligence Development Studio. That's where
> you find the designer you are used to in 2000.
> To schedule the package, create a job and for the step type,
> use SQL Server Integration Services Package.
> There are How To help topics in books online that give step
> by step instructions on how to do this.
> For creating packages, refer to:
> How To: Create a Package Using SSIS Designer
> For scheduling as a job, refer to:
> How To: Run a Package Using a SQL Server Agent Job
> There are many other How To topics for SSIS. Open up books
> online and you will see a How Do I button on the tool bar.
> Select that and chose SQL Server Integration Services.
> There is also a decent tutorial on using SSIS. From the help
> contents, go to SQL Server Tutorials node. Select
> Integration Services Tutorials.
> You can also find information on SSIS at:
> http://www.sqlis.com/
> -Sue
> On Fri, 17 Mar 2006 12:45:27 -0800, Paul
> <Paul@.discussions.microsoft.com> wrote:
>
>
|||ok thanks for the information. I like the way the DTS packages can be easily
designed and scheduled with 2000 Enterprise manager, hopefully these extra
steps will be straight forward (no to difficult or complicated to remember).
Paul G
Software engineer.
"d" wrote:

> they destroyed DTS. and replaced it with a very complicated software called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file. now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
>
|||Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"d" <d@.d.com> wrote in message news:kAZSf.1312$I7.999@.trnddc03...
> they destroyed DTS. and replaced it with a very complicated software
> called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file.
> now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
|||<quote>
Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
</quote>
You can actually still do this. (Took me a little while to find it.)
You just need to right click on the database name and then select Tasks.
Import and Export are options under that. There is also an option to
save the SSIS package.
Hope this helps,
Matt
*** Sent via Developersdex http://www.codecomments.com ***

2005 dts package question

Hi I am working with the trial ms2005 SQL Server measurement studio. I could
not find how to create and schedule a DTS package, guess this is done with
Enterprise Manager with mssql2000. JUst wondering if someone could point me
in the right direction, thanks.
--
Paul G
Software engineer.SQL Server Integration Services (SSIS) is the replacement
for DTS in SQL Server 2005. You create SSIS packages using
the Business Intelligence Development Studio. That's where
you find the designer you are used to in 2000.
To schedule the package, create a job and for the step type,
use SQL Server Integration Services Package.
There are How To help topics in books online that give step
by step instructions on how to do this.
For creating packages, refer to:
How To: Create a Package Using SSIS Designer
For scheduling as a job, refer to:
How To: Run a Package Using a SQL Server Agent Job
There are many other How To topics for SSIS. Open up books
online and you will see a How Do I button on the tool bar.
Select that and chose SQL Server Integration Services.
There is also a decent tutorial on using SSIS. From the help
contents, go to SQL Server Tutorials node. Select
Integration Services Tutorials.
You can also find information on SSIS at:
http://www.sqlis.com/
-Sue
On Fri, 17 Mar 2006 12:45:27 -0800, Paul
<Paul@.discussions.microsoft.com> wrote:
>Hi I am working with the trial ms2005 SQL Server measurement studio. I could
>not find how to create and schedule a DTS package, guess this is done with
>Enterprise Manager with mssql2000. JUst wondering if someone could point me
>in the right direction, thanks.|||they destroyed DTS. and replaced it with a very complicated software called
Integration Services.
Just so you know, you had 4 steps to create an import from a text file. now
you will have no less than 12 steps to do the same. It sucks but what
there's nothing we can do about it.
d.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> Hi I am working with the trial ms2005 SQL Server measurement studio. I
could
> not find how to create and schedule a DTS package, guess this is done with
> Enterprise Manager with mssql2000. JUst wondering if someone could point
me
> in the right direction, thanks.
> --
> Paul G
> Software engineer.|||Ok thanks for the information, will take a look at it.
--
Paul G
Software engineer.
"Sue Hoegemeier" wrote:
> SQL Server Integration Services (SSIS) is the replacement
> for DTS in SQL Server 2005. You create SSIS packages using
> the Business Intelligence Development Studio. That's where
> you find the designer you are used to in 2000.
> To schedule the package, create a job and for the step type,
> use SQL Server Integration Services Package.
> There are How To help topics in books online that give step
> by step instructions on how to do this.
> For creating packages, refer to:
> How To: Create a Package Using SSIS Designer
> For scheduling as a job, refer to:
> How To: Run a Package Using a SQL Server Agent Job
> There are many other How To topics for SSIS. Open up books
> online and you will see a How Do I button on the tool bar.
> Select that and chose SQL Server Integration Services.
> There is also a decent tutorial on using SSIS. From the help
> contents, go to SQL Server Tutorials node. Select
> Integration Services Tutorials.
> You can also find information on SSIS at:
> http://www.sqlis.com/
> -Sue
> On Fri, 17 Mar 2006 12:45:27 -0800, Paul
> <Paul@.discussions.microsoft.com> wrote:
> >Hi I am working with the trial ms2005 SQL Server measurement studio. I could
> >not find how to create and schedule a DTS package, guess this is done with
> >Enterprise Manager with mssql2000. JUst wondering if someone could point me
> >in the right direction, thanks.
>|||ok thanks for the information. I like the way the DTS packages can be easily
designed and scheduled with 2000 Enterprise manager, hopefully these extra
steps will be straight forward (no to difficult or complicated to remember).
--
Paul G
Software engineer.
"d" wrote:
> they destroyed DTS. and replaced it with a very complicated software called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file. now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> > Hi I am working with the trial ms2005 SQL Server measurement studio. I
> could
> > not find how to create and schedule a DTS package, guess this is done with
> > Enterprise Manager with mssql2000. JUst wondering if someone could point
> me
> > in the right direction, thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"d" <d@.d.com> wrote in message news:kAZSf.1312$I7.999@.trnddc03...
> they destroyed DTS. and replaced it with a very complicated software
> called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file.
> now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
>> Hi I am working with the trial ms2005 SQL Server measurement studio. I
> could
>> not find how to create and schedule a DTS package, guess this is done
>> with
>> Enterprise Manager with mssql2000. JUst wondering if someone could point
> me
>> in the right direction, thanks.
>> --
>> Paul G
>> Software engineer.
>

2005 dts package question

Hi I am working with the trial ms2005 SQL Server measurement studio. I coul
d
not find how to create and schedule a DTS package, guess this is done with
Enterprise Manager with mssql2000. JUst wondering if someone could point me
in the right direction, thanks.
--
Paul G
Software engineer.SQL Server Integration Services (SSIS) is the replacement
for DTS in SQL Server 2005. You create SSIS packages using
the Business Intelligence Development Studio. That's where
you find the designer you are used to in 2000.
To schedule the package, create a job and for the step type,
use SQL Server Integration Services Package.
There are How To help topics in books online that give step
by step instructions on how to do this.
For creating packages, refer to:
How To: Create a Package Using SSIS Designer
For scheduling as a job, refer to:
How To: Run a Package Using a SQL Server Agent Job
There are many other How To topics for SSIS. Open up books
online and you will see a How Do I button on the tool bar.
Select that and chose SQL Server Integration Services.
There is also a decent tutorial on using SSIS. From the help
contents, go to SQL Server Tutorials node. Select
Integration Services Tutorials.
You can also find information on SSIS at:
http://www.sqlis.com/
-Sue
On Fri, 17 Mar 2006 12:45:27 -0800, Paul
<Paul@.discussions.microsoft.com> wrote:

>Hi I am working with the trial ms2005 SQL Server measurement studio. I cou
ld
>not find how to create and schedule a DTS package, guess this is done with
>Enterprise Manager with mssql2000. JUst wondering if someone could point m
e
>in the right direction, thanks.|||they destroyed DTS. and replaced it with a very complicated software called
Integration Services.
Just so you know, you had 4 steps to create an import from a text file. now
you will have no less than 12 steps to do the same. It sucks but what
there's nothing we can do about it.
d.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> Hi I am working with the trial ms2005 SQL Server measurement studio. I
could
> not find how to create and schedule a DTS package, guess this is done with
> Enterprise Manager with mssql2000. JUst wondering if someone could point
me
> in the right direction, thanks.
> --
> Paul G
> Software engineer.|||Ok thanks for the information, will take a look at it.
--
Paul G
Software engineer.
"Sue Hoegemeier" wrote:

> SQL Server Integration Services (SSIS) is the replacement
> for DTS in SQL Server 2005. You create SSIS packages using
> the Business Intelligence Development Studio. That's where
> you find the designer you are used to in 2000.
> To schedule the package, create a job and for the step type,
> use SQL Server Integration Services Package.
> There are How To help topics in books online that give step
> by step instructions on how to do this.
> For creating packages, refer to:
> How To: Create a Package Using SSIS Designer
> For scheduling as a job, refer to:
> How To: Run a Package Using a SQL Server Agent Job
> There are many other How To topics for SSIS. Open up books
> online and you will see a How Do I button on the tool bar.
> Select that and chose SQL Server Integration Services.
> There is also a decent tutorial on using SSIS. From the help
> contents, go to SQL Server Tutorials node. Select
> Integration Services Tutorials.
> You can also find information on SSIS at:
> http://www.sqlis.com/
> -Sue
> On Fri, 17 Mar 2006 12:45:27 -0800, Paul
> <Paul@.discussions.microsoft.com> wrote:
>
>|||ok thanks for the information. I like the way the DTS packages can be easil
y
designed and scheduled with 2000 Enterprise manager, hopefully these extra
steps will be straight forward (no to difficult or complicated to remember).
--
Paul G
Software engineer.
"d" wrote:

> they destroyed DTS. and replaced it with a very complicated software calle
d
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file. no
w
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
>|||Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"d" <d@.d.com> wrote in message news:kAZSf.1312$I7.999@.trnddc03...
> they destroyed DTS. and replaced it with a very complicated software
> called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file.
> now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>|||<quote>
Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
</quote>
You can actually still do this. (Took me a little while to find it.)
You just need to right click on the database name and then select Tasks.
Import and Export are options under that. There is also an option to
save the SSIS package.
Hope this helps,
Matt
*** Sent via Developersdex http://www.codecomments.com ***

2005 backup scheduler

I can not see the schedule option in the backup database window of sql server 2005.
Any thoughts please?Make a new SSIS Maintenance plan, scroll down to the Mangagement node, expand, right click the Maintenance Plan node and select either New Maintenence Task or Maintenance Plan wizard. The Maintenance plan gives you the scheduling options.

2005 backup

I am going through the maintenance plan to create a schedules backup.
Everything seems fine until the final stages of the backup schedule setup when the system gives the following error.
create failed for jobStep SubPlan.

p.s I am not sure how to attached a snapshot of the error message.

Thanks

You need to install SQL Server Integration Services. Run setup and then install .