You job is probably running as sa, correct?  If so, it is running under the security context of the account running SQL Server Agent.  This user needs to have access...

If you can run the DTS packages manually, but they fail as a scheduled job, then it points to a permissions issue for the user under which the DTS jobs...

Well said Keith.

I have to agree with Ken, Joe.  After reading your response

above plus several others, you are down right mean and unhelpful.

You may be a smart SQL Server Guru and a...

Instead of a CASE statement, try this in your where clause instead:

((@BrokerType = 'NON_AFFILIATED' and affiliation.affiliatedcompanyid is null)

or (@BrokerType = 'AFFILIATES' and affiliation.affiliatedcompanyid is not null)

or (@BrokerType = 'BOTH'))

HTH,

Lynn

lost part of the post.  The where clause would be this:

where billdate >= @dt3 and billdate < @dt

again hth,

Lynn

add the following to your snippet:

declare @dt3 datetime

set @dt3 = dateadd(mm, -1, @dt)

select @dt, @dt3 --> 2006-06-01 00:00:00.000  2006-05-01 00:00:00.000

a where clause selecting on dates would look something like this:

where

Looking at your screen prints, it looks like your SQL Server Management Studio connection to "Kenny" is also looking at your SQL 2000 instance.  The version number showning there is...

You probably installed SQL 2000 first as the default instance.  When you installed SQL 2005, you had to install it as a named instance.  In your connection string, you are...

Your transaction log for the BossData database is most likely full.  You need to truncate the transaction log and then do a full backup of the database.

Check you disk drives...

I agree with the above comments.  A full database backup does not truncate the transaction.  Enough of the transaction log is backed up so as to create a stable backup...

There are 2 other alternatives.  The first is to write a Service program that monitors the ftp log file (a text file) looking for a successful ftp of each of...

Here is one solution:

create

table dbo.SalesLine (

docdate datetime,

product

varchar(

Kirk,

Thanks for the info on getting an error description out of an error code.  I was just starting on trying to figure out how to accomplish this ina package i...

You need to set the trace flag 1807 to configure SQL server to with network-based database files.  You can find a list of some of the documented and undocumented trace...