If you want to save all of your DTS Packages to Structured Storage Files.. You may want to try using the following script:

CREATE PROCEDURE [dbo].[xp_DTSExportPackage]

@Path varchar(128) = 'C:\DTSExport\'

AS

set nocount on

declare...

This will fail everytime any of your parameter data contains a single quote character. 

For a quick solution, scrub your data for invalid characters and replace "'" with "

Not sure if this would matter in your environment, but I usually use the files DateLastModified property and not the DateCreated property.

Some methods of File copies will retain the Create...

I have done the following to decrease downtime while performing daily catalog rebuilds.

-Build a duplicate temp table(s), matching the original live data table(s).

-Insert all data into the temp table(s).

-Truncate the...

Another, sometimes easier solution, is to allow access to the share by granting permissions to the Machine Account of the SQL Server via the active directory.  This will allow you...

Yes, DTS can accomplish this by either using the FTP Task or by using a 3rd pary COM+ component that is available to an Active-X Script Task.. if you need...

Well, since this is a DTS forum and you are reading the rows from Access; this would be a DTS solution... this would not be a good candidate for a...

You can read in the Binary data from the File URL with the following function, then set your insert parameter of your stored procedure to the return value of the...

Use an Active-X task script to open the file as a TextStream

use a loop like such:

set objFile= objFS.OpenTextFile("c:\somefile2.csv", 1, false)

WHILE NOT objFile.AtEndOfStream

  sLine = objFile.ReadLine

  '** Process the Line

WEND

Mike...

Here is another site that should give you 99% of what you'll ever need:

http://www.devguru.com/

Mike Gercevich

P.S. note that what you have asked for are not DTS Objects but are Active-X...

Maybe you could add a bit more detail to what you are attempting to do.  If you are trying to get the data returned in the results window to wrap text...

Scott,

I have tried to give away my other utility in hopes of having some good feedback sent back to me... I wrote a utility to compare DTS packages between servers, and...

Try this... Open the Package up in Designer.. select everything... open up a new Package and paste them into the new package... now save it.

That may save you some time...

Scott,

DTS Packages are stored as COM structures, therefore you cannot search for texual entities in them.  The Structured Storage File is a collection of COM Structures.. meaning it can contain...

Couple options that may help....

Export the DTS Package as a Structured Storage file and give them instructions on how to open it and execute it.

Or, Save the package as a...