Nali,

You'll need more information to troubleshoot this.  Enable package logging in Package Properties Logging tab.  Execute the package and look in the log.

Greg

Luke,

Is the output text file on the same server as the DTS package?  When you execute the package in DTS Designer, are you on the server where the package resides...

Joshua,

Check out this article from sqldts.com:

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

Greg

If the text file is has many different record and field lengths, you'll have the same problem in DTS.  You could possibly import the file into a staging table with...

Another method:

If the table isn't referenced by a foreign key constraint, you could TRUNCATE the table to reset the identitiy seed.

Greg

Will,

Check this thread on the same subject.  I assume you mean "session" when you say "instance"?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=114165

Greg

The best place to start is with Microsoft's upgrade recomendations at http://msdn2.microsoft.com/en-us/library/ms144245.aspx

The Upgrade Advisor is especially useful for seeing what will need to be dealt with in DTS packages...

Ayman,

The article was posted a year ago.  If you look at the sqlservercentral.com homepage you'll see the link for it in a section titled, "One Year Ago".

Greg

We have 15, all running SQL Server.  1 crash&burn, 2 development, 1 demo, the rest production.

Greg

Andrew,

See this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=296781&edit=1

Greg

Alan,

Do you need to copy the table structure or just the data?

Greg

If a step is dependent on multiple precedence constraints i.e. workflows, all precedent constraints must be 'true' for the step to execute.  In other words, precedent constraints operate as 'AND'...

I use Terminal Services all the time to execute DTS packages, particularly those with connections that use ODBC DSNs because the DSN may be different on the server than on...

Brian,

Here's how to find the recovery model for a particular database (named 'NSF').  SP_HELPDB uses this to find database properties.  Maybe you could modify it to work with sp_MSforeachdb to...

Sorry about that.  You're supposed to replace 'user' with the username that you're interested in.  You can see the syntax in BOL.

As for your second question, try this query:

select...