I suggest that you also look at your data and set your max column lengths to a realistic number.  255 characters seems too long for any name or address, not...

MSDE is a free redistributable version that can be included in applications.

Here's the MS description of the uses for MSDE version:

http://www.microsoft.com/sql/evaluation/overview/default.mspx

Greg

ALTER PROCEDURE permissions are not transferrable, according to BoL.  See "Alter procedure" in BoL. 

I suggest, as Remi was getting at, that you add the user to the fixed database...

Jan,

I think you'll need to use an activeX task to modify the workflow.  There's a method illustrated on http://www.sqldts.com that you probably can modify to fit your need.  See...

Since it doesn't sound like you are currently backing up the transaction logs, do you want to do it for "point in time" or "point of failure" recovery or are...

Sanyjay,

If you know the interval between exports, you can schedule the DTS package to run at that interval.  If it depends on certain data being in  a source table, you...

Could you explain in more detail what you're trying to do?  Do you have two text files that you'd like to import to the same table in SQL Server?

Greg

I don't know of a way to change something in all the packages without opening each one, but here's a thread that describes several ways to avoid that situation:

Use the TEXT data type.   See 'text data type' in BookonLine.

Greg

SET DATEFIRST 1 makes Monday the first day of the week.  SET DATEFIRST 7 makes Sunday the first day of the week. 

From BOL:

SET DATEFIRST

Sets the first day of...

I'm glad it worked for you.  I had to learn the hard way through trial and error.  No use everyone going through that!

Greg

Hi Cheryl,

Yes, you can change a connection without having to recreate the Transform Data task.

First, create Data Link connection in the package.  Then, open the properties of the OLE DB...

Kevin,

This article on SQLDTS.com describes your problem and suggests using the DTSStepScriptResult constants to get around it.  I haven't used it myself, but remembered seeing it on the site.

Greg

http://www.sqldts.com/default.aspx?211

Hi Helen,

That will work.  You'll end up with two packages with different names and different owners.  This isn't a work around for your original problem, however, because you can't save the...

I wonder if this custom task will be updated to work with SSIS in SQL Server 2005.  I'd be cautious about using it in packages that will be run in...