Never. Because we have a DB with private information (privacy area designed by law). For testing we backup production DB, restore in stndl. server and run an application that mixing...

In my experience is lookups very slow ... my solution: rewrite original DTS (with lookups) to pure SQL (with joins)

****************************************

1: The question is ... "What is a MahnaMahna"?

2: The question...

Use DTS COM model to execute package and handle relevant events triggered within execution.

1: The question is ... "what is a MahnaMahna"?

2: The question is ... "Who cares?"

Use DBCC SHRINKFILE and read BOL for explain

quote:

---

Is there a way to migrate DTS packages from 7.0 to 2000 without doing them one at a time? I would...

quote:

---

Hi!!

I would like to know, how is it possible to create a .csv file using a dts, extracting data from a table.

...

Or you can use ActiveX Task to set each property of each task in your DTS. If you have a different headers of DBF or CSV, you must use ActiveX...

You can write a small WSH (VBS) script with using DTS COM Library and run this script via cscript.exe.

heh ... i found this know-how ... Q290915 (MS Knowledge base) ... http://support.microsoft.com/default.aspx?scid=kb;en-us;290915

But i don't understand the Status paragraph:

This problem was first corrected in SQL Server 2000 Service...

In EM right-click on the Data Transformation Services and select Open package ...

If you haven't EM, you can write a small WSH script with DTS COM Library ... see LoadFromSQLServer,...

You can write a simple WSH script (.VBS, .JS) using DTS library to load DTS packages from SQL Server and save to StorageFiles to disk and second script to load...

hm ... UltraEdit is better than Edit plus ... IMHO ... I'm using UE from 6.x version and UE is my preferred editor for all programming (JScript, Java, C/C++, T-SQL,...

I prefer using DTS for any time ... DTS have a BCP insert task and have more sophisticated tasks which helps me in ETL processing.