Are you wanting this?

SELECT replace(replace(FieldA, '+', ''), '%2E', '.')

Looks like you want 4 outputs, if the above does not meet your needs then what are you starting with and what...

Ok when you run it thru EM are you executing from your machine or the server. If you machine then keep in mind xp_cmdshell will actually execute it on the...

How are you defining your connection to the dts package in DTSRUN -E for trusted or a named account. If the later or even the first it may not have...

I am not sure as I have only use MySQL once so far and that was testing over a year ago. You might try like so.

You may need to start...

Then I think you may be going overboard. If you are writing to flat file then you can use any text data type and use either tab delimination or comma...

Visio can reverse engineer as well which if Ent Arch is MS product then they are related. Much of the other stuff can be done using DMO (VB, VC or...

It may be a fluke that just occurred but check in Event Viewer and SQL Server Logs to see if any other specific event occurred around the time the problem...

First have you tried restarting the service and the server to see if the issue goes away? In addition are there any other processes that could be hung such as...

This is the reason for periodic backups. You might try sp_resetstatus on the DB then restart server to see if recovers, otherwise you have lost the TL I do believe.

...

It requires you to use Dynamic SQL like so

CREATE PROCEDURE ip_SP

@tablename varchar(255)

AS

EXEC('SELECT * FROM ' + @tablename)

or some other similar type of Dynamic SQL.

I like them primarily when I may have a value that can be NULL just so that all the parameters do not need to be expressed. But to make usefull...

Looking this over I made several changes that should increase the effency of the code but do test it before you make the changes. Also, noted a second spot where...

Ok

couple additional pieces about this I think I should include since I brought it up.

WHERE convert(char,dates,101) BETWEEN '12/01/02' AND '12/31/02'

If does definently not use an index if one exists so...

I believe your problem is that MySQL does not have an object owner part of the name. It is db_name.object_name. Try this

Select * from Localhost..testname

or

Select * from Localhost.db_name.testname

or

Select * from...

To know for sure create another package from the first using save as but remove the need to access the drive. Then set the use back and see...