I assume you're using a Transform Data task to copy the data. In the Source tab of the task, use a SQL query rather than just selecting a table...

You're trying to import a char column (DBTYPE_STR) into a smallint column (DBTYPE_I2). Try using CAST or CONVERT when selecting the source data rather than just doing a column...

No. You'll have to drop the full-text indexes associated with the catalog before you drop the catalog itself. See 'full-text datalogs, removing' in BOL.

You're sure you...

I have to agree with Sergey that it's unlikely someone would be able to decrypt the password from the script, but you can store the script in a secured directory...

We used backup/restore.

Then I suggest you do the catalog rebuild. We had to do that with full-text catalogs after upgrading.

I believe that file is used by full-text search. Has the database been upgraded from SQL 2000 by any chance? To fix it, try rebuilding the full-text catalog.

The link works now. Must have been a transient problem.

In any case, here are the stored procedures:

sp_enum_dtspackagelog

sp_enum_dtspackages

sp_enum_dtssteplog

sp_enum_dtstasklog

sp_get_dtspackage

sp_get_dtsversion

sp_drop_dtspackage

sp_add_dtspackage

Duplicate post. Direct replies here: http://www.sqlservercentral.com/Forums/Topic789390-364-1.aspx

Duplicate post. Direct replies here: http://www.sqlservercentral.com/Forums/Topic789390-364-1.aspx

Duplicate post. Direct replies here: http://www.sqlservercentral.com/Forums/Topic789390-364-1.aspx

I'm not clear about where everything is located. Are the upload job and upload package on the same server as the .TXT files? If not, change the connection...

Here's how I've done it.

1. Download and install the SQL 2000 DTS Designer components and DTS runtime components http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en.

2. Save the DTS packages in the SQL 2000 instance...

SanthoshViswanathan,

Do you execute packages in agent jobs? If so, is the DTSRun command in plain text or is it encrypted? If a user can see the DTSRun command...

Restoring a database from a backup restores everything in the database, including users and permissions.

If you need to copy only permissions, you'll have to script them. There are several...