I havn't got a SQL server 7 installation to test but the qualifier is configurable in SQL2K:-

Add a dynamic properties task.

Open it's properties and click Add.

In the text file connection...

To create the procedure:-

CREATE PROCEDURE spsl_Test

@Activitychar(1)

,@Numvalint output

AS

select

@Numval = sum(Numval)

from

test

where

ascii(Activity) >= ascii(@Activity)

To execute:-

EXEC spsl_Test @Activity, @Numval OUTPUT

Regards,

Andy Jones

Try:-

select

<col list>

from

a

left outer join b on a.? = b.?

left outer join c on a.? = c.?

Regards,

Andy Jones

You're right, this column does seem a mystery with nothing in BOL (all my jobs are set to 'Yes'). I ran profiler against the population of the jobs screen, it...

Increase the CommandTimeout property on your ADO connection.

Regards,

Andy Jones

Are you just passing variables into MyFunction and not column values? If so then create a new SP instead of MyFunction e.g.:-

declare @i1 int

declare @i2 int

exec sp_MyFunction @intA, @intB,...

Investigate the dtrun command line utility. Type dtsrun /? at the command line for all options. Then call this using xp_cmdshell e.g.

exec master..xp_cmdshell 'dtsrun /f "C:\Import\CI.dts" /W TRUE'

Regards,

Andy Jones

I saw the results you originally described i.e.

declare @s-2 varchar(100)

select @s-2 = 'zzz'

select @s-2 = [name] from sysobjects where 4=5

select @s-2

...

You could use the truncate table command instead of delete if you are deleting all the rows in the table.

Regards,

Andy Jones

No, files are from a third party app.

Regards,

Andy Jones

andyj93@hotmail.com

When you say "roll back the package and rerun it" how do you mean? You want to keep executing step 1 until the source file does not exist?

Regards,

Andy Jones

andyj93@hotmail.com

See the isnumeric, right, left and len functions in BOL to achieve this.

Regards,

Andy Jones

andyj93@hotmail.com

CREATE TRIGGER [tg_Emp_Up] ON dbo.Emp

FOR UPDATE

AS

update Emp

set Mod_Date = getdate()

from Emp e

inner join Inserted i on e.EmpNo = i.EmpNo

inner join Deleted d on i.EmpNo = d.EmpNo

where i.Salary !=...

In EM right click on the DB - All tasks - Detach Database. Then move the files and attach the files back to the SQL Server using All Tasks -...

The problem I have is that the file is not in any pre-defined format for example it could be:-

1,2,3,4

1

1,2

1,2,3,4,5

so there is a random (known maximum - say 5) number of...