dbTalk Databases Forums  

Package calling another package

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


Discuss Package calling another package in the microsoft.public.sqlserver.dts forum.



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

Default Package calling another package - 04-04-2004 , 07:46 AM






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





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

Default Re: Package calling another package - 04-04-2004 , 09:56 AM






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 (AT) wmdata (DOT) dk> wrote

Quote:
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







Reply With Quote
  #3  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: Package calling another package - 04-04-2004 , 02:51 PM



Thanks Allan


Allan Mitchell <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
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 (AT) wmdata (DOT) dk> wrote in message
news:eLFNFJkGEHA.684 (AT) tk2msftngp13 (DOT) 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









Reply With Quote
Reply




Thread Tools
Display Modes

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.