Re: Calling Stored Procedure in DTS

From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
Date: Sun, 12 Aug 2007 20:04:47 +0100

I'd generally advise taking all the TSQL out of packages and placing in
stored procedure calls, assuming the datasource refers to a sql server
database. This way when you need to do some global changes you can query
syscomments quite easily. We have a case in point where we need to find all
instances where a linked server is referenced, before we migrate databases
to a new box. Having code tucked away in packages is a real pain here!
Cheers,
Paul Ibison

.

Prev by Date: It keeps appending in excel?
Next by Date: Re: Why save SSIS using integrated security
Previous by thread: It keeps appending in excel?
Next by thread: Authentication issues vb.net and DTS command line project
Index(es):
- Date
- Thread

Relevant Pages

Re: Need to recover DTS files from computer crash
... In terms of the DTS packagnes...if you saved your DTS ... packages to SQL Server then they will be in the msdb ... >1) To bring up a new database file into SQL Server 2000 can I just use the ...
(microsoft.public.sqlserver.server)
Re: DTS transfer from Paradox to SQL Server 2000 using SQL Agent
... Agent jobs. ... The DTS Packages collects data from a Paradox database located locally on the SQL Server machine and inserts the data in a SQL Server 2000 database. ...
(microsoft.public.sqlserver.dts)
Cannot import data from Access 2000 database too SQL server 2000
... If I try to import a table in sql server 2000 sp3 enterprise manager, ... choosing my access 2000 database as source and my sql server as destination, ... Faulting application mmc.exe, version 5.2.3790.0, faulting module ... Old packages work though. ...
(microsoft.public.sqlserver.dts)
Re: DTS packages on new SQL Server
... I found out how to do this by right clicking on the DTS folder in EM ... >> They are stored in the MSDB database, but moving that database is always ... You can load the DTS packages into Enterprise Mangler and save ... >> I support the Professional Association for SQL Server ...
(microsoft.public.sqlserver.server)
Re: MS Access DAO -> ADO.NET Migration
... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
(microsoft.public.dotnet.framework.adonet)