Re: DTS packages in SQL 2000 slow to open

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 21:20:35 +0000

OK

Can you tell me what is in the package?

All packages do this or packages of complexity only?

SP level on SQL Server, MDAC?

Anything in the Event Log?

"softengine" <softengine@discussions.microsoft.com> wrote in message
news:softengine@discussions.microsoft.com:
> Well at first I thought it was how we transferred the packages from the
> old
> SQL Server to the new and faster SQL Server. We used a free program called
>
> DTSBackup 2000. But then I created a test package directly on the new SQL
>
> server and I get the same problem.
>
> When I take a package and try to do a Save As to either a Structured
> Storage
> File or metadeta, it takes a long time to save and just as long to open.
>
>
> "Allan Mitchell" wrote:
>
> > What happens if you save the package to a structured storage file and do
> >
> > it from there?
> >
> > "softengine" <softengine@discussions.microsoft.com> wrote in message
> > news:softengine@discussions.microsoft.com:
> > > We have several instances of SQL Server 2000(sp3) on a Windows 2003
> > > development box. (3gigs ram, dual P4 2.8ghz xeons).
> > >
> > > We are experiencing a problem where DTS packages are taking an
> > > unusually
> > >
> > > long time to open. This only occurs when using EM on other clients and
> > > not
> > > on
> > > the actual local server. I have tried turning on CACHE but it doesn't
> > > seem
> > > to
> > > work. If you have any ideas or could at least explain how or why it's
> > > slow
> > >
> > > please send info this way. Incidentally, small and simple packages
> > > open up
> > >
> > > much quicker than the large complex ones.
> > >
> > > I realize complex/large DTS packages will take longer to open
> > > because
> > > metadeta is being collected when a package is open, but these packages
> > > are
> > >
> > > taking twice as long to open than they did when they were on a much
> > > slower
> > >
> > > sql server.
> >
> >

Relevant Pages

  • Re: Sql Server Agent (2000) erroring out on DTS Packages
    ... DTSRun: Package execution complete. ... and a problem with a missing MDAC dll. ... On Sql Server 7, this was SQLAgentCmdExec. ... Specified driver could not be loaded due to system error 126 (MERANT MSSS ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: DTS package disappearing
    ... When you create a new package and then save it, you have the option to save ... If you save it to SQL server, you also need to select which SQL server you ... To open structured storage file, ...
    (microsoft.public.sqlserver.dts)
  • Re: Migrating DTS Local Package from test to production environments v7.0
    ... The version of SQL Server on which the package was create is SQL Server ... DTS runs at the client so manually will be on the invoker's PC which in this ...
    (microsoft.public.sqlserver.dts)