There could be several issues. Is your UI program getting an error messages? Are you guaranteed to have connectivity between the 2005 server and the linked 2000 server?...

Can you explain your reason for needing this? I think the designed way for SSIS to handle this is to use the Row Count transform.

Here is a link to a script I submitted that will find all foreign keys:

http://www.sqlservercentral.com/scripts/foreign+keys/64333/

It wouldn't be too hard to extend it using sys.index_columns and sys.indexes

You would need to setup Linked Servers on the SQL Servers and either grant login rights to the users on both servers and use "pass-through" authentication or map users on...

The error is telling you exactly the problem the text file is returning a non-unicode string and the database column is a unicode string type (nchar/nvarchar) and you need to...

Can you post the .NET code that is generating the error?

If you are trying to insert NULL it will fail because the column does not allow NULLs and if you...

In SSMS you can run a Disk Usage by Table report by right-clicking on the database, selecting Reports, and then selecting the Disk Usage by Table Report. This may...

Yes you can do it, but your package will need to be more complex as you will not be able to just do an insert. You will need a...

Unless you manually shrink a database or autoshrink is on SQL Server will not return space to the OS. It will re-use the space.

Does sys.allocation_units show many unused...

The default profile is setup as part of the Database Mail setup. In SSMS connect to the server go to Management -> right-click on Databas Mail -> Configure Database...

This from a personal email and posted here so others can benefit.

hello jack , thanx for your advise, can u please tell me , in the script , i know...

Yes a true TRIM function would be nice. I actually had an issue recently when querying FoxPro data in SSIS around trimming. FoxPro has a 4 functions for...

Thanks.

Thanks, Jeff. I actually put a lot more time into the code than the article.

Yeah, I know that it is turned off by default at the Database level,...

I think you mean sp_send_dbmail. In SSMS you can right-click on Database Mail and either View History or View Log.

My guess is that you did not set up a...