there are header also on my test file on workstation.... i've  solved changing the modifying the extend properties of excel connection and setting IMEX=1

the problem is that on my pc...

sorry, the line:

    set @comp_date = @comp_date - 1

is wrong (good to compute the previous friday). use this

    set @comp_date = @comp_date + 1

for the same scope i've used this function. is useful also to compute the previous friday.

CREATE FUNCTION Next_Friday

   (@ref_date datetime)

RETURNS datetime

AS

BEGIN

declare @comp_date datetime

DECLARE @ddayVARCHAR (15)

declare @X varchar

SET @COMP_DATE = convert(varchar(2),datepart...

mmhhh.... or you could try to solve your problem in this way:

import all the sheet adding 2 columns: the first for record id (so there will be 3 records with...

may be this post is not in the right section: here is to talk about DTS and you ask for something that is better to do with other tools (query...

hi pinky,

try using wizard and bywizard save your dts. then you can check the difference between the one realized by wizard and your one.

i've exported table with more than 50...

you can realize a stored procedure that, using a cursor, analyze the field and update it as you want and then put the call to this procedure into an 'execute...

i don't know if it works but... i'm confident of it!

try this, instead of oFSO.CopyFile  use oFSO.CopySheet and see if it works, so in the excel file you'll have...

i've found this example lot of time ago....and i've used with success...

using active x:

' Copy File

Option Explicit

Function Main()

i see only that you must specify the attachment as a string so:

 @attachments = 'C:\Documents and Settings\Desktop\test.xls'

that is different from 

 @attachments = C:\Documents and Settings\Desktop\test.xls'

sorry for my english...

i've found this about that error

http://support.microsoft.com/kb/555180/en-us

it works without the attachment?

are you sure the file to be attached was created?

which is the error??

you can use an "execute sql task"

use a select count(*) from tabletoexport

if count(*) > 0

    xp_sendmail

end if