Viewing 15 posts - 1,486 through 1,500 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 8:46 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 7:15 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 7:13 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 16, 2003 at 10:31 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 16, 2003 at 7:12 am
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
...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 14, 2003 at 11:52 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 11, 2003 at 7:20 am
-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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 10, 2003 at 2:40 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 10, 2003 at 10:07 am
Take a look at http://www.microsoft.com/sql/techinfo/deployment/70/msde.asp
Hope this helps get you started.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 9, 2003 at 2:36 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 9, 2003 at 10:00 am
It gives me hope that it can be worked around. Thanks Andy!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 9, 2003 at 8:23 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 2, 2003 at 7:27 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 2, 2003 at 7:16 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 2, 2003 at 7:12 am
Viewing 15 posts - 1,486 through 1,500 (of 1,790 total)