Glad it worked!

I'm new to SSIS, but if it is like DTS in SQL Server 2000, when you run it manually from your desktop system, it sees the mapped drive.  When run...

Not really sure but I think it is a simple case of missing comma's.  Compare this insert to the original and let us know.

     INSERT INTO my_table (comments,

                                       sr_status,

                                       sr_notes_count,

                                      ...

Not too sure from your sql command, but I would guess you are appending your differential backups to the same file.  This will cause your differential backup file to grow...

It means that enterpriselistid must unique in every row.  Sounds like you are trying to insert a new row with an enterpriselistid that already exists in the database.

hth

try this

declare @vchar vchar(20)

set @vchar = '1458.00'

select cast(substring(@vchar, 1, patindex('%.%', @vchar) - 1) as int)

hth

I come up with 1152 characters in your option string.

First, you can have a multiline constant, try this and see:

declare @options nvarchar(4000)

set

@options='replace,

move ''CorpProd_Data1'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Primary.mdf'',

move ''CorpProd_Data2'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Data1.ndf'',

move ''CorpProd_Data3'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Data2.ndf'',

move ''CorpProd_Data4'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Data3.ndf'',...

Careful with my code above, I just noticed the inner on the inner join typed twice!

Reformatted your code and found what I think is the problem inthe subquery at the end.  Check it out:

select

    p.vendor_code,

    p.vendor_name,

    p.vendor_addr_l1,

    p.vendor_addr_l2,

    p.vendor_addr_l3,

    p.vendor_addr_l4,

    p.vendor_addr_l5,

    p.vendor_addr_l6,

    p.vendor_addr_l7,

    p.vendor_addr_l8,

    p.vendor_phone,

   ...

True.  But that also depends on the actual query and what is wanted.  We only see two columns in the query on-line, but what if they wanted to most recent...

I have had this problem with maintenance plans when I have gone in to modify them.  I found I usually had to delete the problem plan and recreate it from...

Or you could do this:

select

    cust.custID,

    cust.CustName

from

    dbo.customer cust

    inner join dbo.payment pay

        on (cust.CustID = pay.CustID)

where

    pay.DatePayment > '2004-08-01'

    and (cust.CustID like '10%' or cust.CustID like '20%')

    and pay.DatePayment...

Not sure which alias to use for column disposition, but try moving "disposition in ('ER''ER/CF','WD/ER') into the join statement.

hth,

Lynn

The transaction log file is only truncated by a transaction log backup.  When SQL Server truncates the log file (and it may not shrink the actual size of the file),...