A global variable would be the way to go. Specify the initial file name as your destination connection then prior to Transformation Task in the package insert a dynamic properties...

Detach the databases, move the physical files to the location that you desire and then attach the databases with the proper path specified. See sp_detach_db and sp_attach_db in Books On...

Well, I thought that this was a problem associated with the upgrade however, the problem is actually with the type of connection string used by the code that worked fine...

Your backup software will not back them up while the service is running. You will need to stop the service prior to taking a backup.

Best solution in my opinion...

I am assuming that "But, I can apply the *.trn files." should have read "can't apply the *.trn files"? If that is what you meant to type, then my question...

Sorry, missed the additional insert....

Try this;

select

b.Value

, d.Value

from

(select distinct(a.value) from Test a where a.Code = 'a') b

...

Not sure if Sybase will handle correlated sub-queries but if it will, try the following;

select

distinct(Value) as AValue

, (

select distinct(value)

from Test b

where

Code = 'b'

and b.Value = a.Value

) as BValue

from...

-Create a temp table that matches your text file structure

-Import the data in from the text file into the temp table

-Delete from the main table where the records exist in...

In your given example the database knows that it was backed up at 9:15 and if you were to restore that backup using the no recovery option followed by a...

Take a look at http://www.microsoft.com/sql/techinfo/deployment/70/msde.asp

Hope this helps get you started.

David

Figured it out. I am at a new company and my old tools are gone including installation CD's. Install that was provided to me was a Developer Edition Install which...

It gives me hope that it can be worked around. Thanks Andy!

David

There are a couple of stored procedures you can look into to get the information you are looking for. My favorites are sp_helprotect, sp_helpuser, sp_helplogins.

You can also look up...

It appears that the SQL Server Agent does not have permissions to gain access of the Excel file where you do. When you run the package manually you are passing...

Yes as the service actually has the password typed into it. You will need to change the password and then restart the service.

The thing I am not sure about...