Sounds like your code is converting a char to a datetime and SSIS does not like it. Can you post the code?

Part of the problem here is you are limiting yourself with a stored procedure. Why not directly update the mailing address table? This is assuming that you are...

Truncate can be rolled back if wrapped in a explicit transaction by the same session; however, I believe the major difference is that the data pages are deallocated for truncation....

If the table has an identity field with seed, why are you trying to insert a value for it? I do not see why you need to insert the...

You could also maintain a separate table with all of your table names and the other pertinent information you need. Then set up DDL triggers on each of your...

As Jack said it is difficult to tell you the answer if we have no code or DDL to base our answer on. A few possible reasons come to my...

the process should be sqlwb for all editions except expess, which should be ssmsee

Look to see if the process is running, in task manager. Also have you tried rebooting the machine?

Does SSMS not open or does an error message appear?

You need to open configuration manager to change the port the instance is running on. If you open Configuration manager, There is a tab for SQL Networking Configuration. ...

I am not sure why you are recieving your output like that. You XML looks good and I even took your sample and made a quick runthrough and everything...

This link should help. It does exactly what you are asking for.

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

The actual file is stored in the database as what type of column? VARBINARY? I belive you can use BCP to output a file.

Your right this is a 2005, I must have missed the requirement for 2000. You should be able to use the database properties though.

EXEC master..sp_MSForeachdb '

USE [?]

--IF THE CURRENT...

You need to do some checking in you msforeachdb statement. You will note I also excluded system databases you can take that out if you dont need it.

EXEC master..sp_MSForeachdb...