Re: Package calling another package

From: Michael Vardinghus (mivar_at_wmdata.dk)
Date: 04/04/04

  • Next message: Andreas Terzis: "Re: Executing a DTS from another DTS..."
    Date: Sun, 4 Apr 2004 21:51:55 +0200
    
    

    Thanks Allan

    Allan Mitchell <allan@no-spam.sqldts.com> wrote in message
    news:u25cYTlGEHA.3880@TK2MSFTNGP10.phx.gbl...
    > It sounds as though you are having problems with versioning of the
    packages.
    > This can be asily fixed/Worked around by doing this
    >
    > Make the Execute Package Task name dependent only
    > (http://www.sqldts.com/default.aspx?216)
    >
    > Saving the packages in SQL Server means you can back up the packages as
    part
    > of your backup routine.
    >
    >
    > --
    >
    > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
    > www.SQLDTS.com - The site for all your DTS needs.
    > I support PASS - the definitive, global community
    > for SQL Server professionals - http://www.sqlpass.org
    >
    >
    > "Michael Vardinghus" <mivar@wmdata.dk> wrote in message
    > news:eLFNFJkGEHA.684@tk2msftngp13.phx.gbl...
    > > Is there some way I can get the "father"-package to automatically detect
    > > changes in the "son"-package and update
    > > the link ?
    > >
    > > When changin something i have to open the father-package and point to
    the
    > > son-package again.
    > >
    > > And another thing ... what are the pro's and con's of saving packages to
    > > sql-server og as structurede storage files - are the latter only for
    > > transportation ?
    > >
    > > \Michael Vardinghus
    > >
    > >
    > >
    > >
    >
    >


  • Next message: Andreas Terzis: "Re: Executing a DTS from another DTS..."

    Relevant Pages

    • Re: Upgrading DTS to SSIS
      ... You cannot run packages outside of BI Development Studio on a client computer that does not have Integration Services installed, and the terms of your SQL Server 2005 licensing may not permit you to install Integration Services on additional computers. ... SQL Server 2005 Integration Services (SSIS) is now a server component and is not redistributable to client computers in the same manner that the components required for SQL Server 2000 Data Transformation Services (DTS) were redistributable. ...
      (microsoft.public.sqlserver.dts)
    • Re: Editing DTS Packages on a 64-bit SQL Server 2005 installation
      ... The tips for running 32-SSIS packages can be extended to running 32-bit DTS ... store your DTS packages in a 64-bit SQL Server database. ... have tried installing the Web download it says to install but then I get ...
      (microsoft.public.sqlserver.setup)
    • DTS package permissions errors when transferring pkgs btw servers
      ... I have a DTS problem that's been giving me fits and am hoping someone here ... configuration & operate similarly to the source machine. ... Server service and SQL Server Agent logins, (they use mixed mode security - ... There are 40 odd DTS packages, which I transferred (by using Save As for the ...
      (microsoft.public.sqlserver.dts)
    • SQL Server 2005 Workgroup Edition und SSIS
      ... The Business Intelligence Development Studio option installs the Integration ... and you cannot run packages outside of BI Development Studio. ... Mit dem SQL Server 2005 Workgroup Edition werden Teile der Integration ...
      (microsoft.public.de.sqlserver)
    • Re: Bam.xls
      ... Services" using the SQL Server Management Studio and look under the Stored ... DTS packages that have been dynamically created. ... I was astonished that there was no cubes are created. ... So where does data come from in the BAM portal? ...
      (microsoft.public.biztalk.general)