Y'all are missing the point. Here's an example:

create table #test (field varchar(1))

insert into #test (field) select 'a'

update #test set field = 'abcd'

The update statement will fail with the message:

Server:...

Start by checking out Extended DTS Objects in bol. Sorry, I don't have time to look into this further right now. If you find a solution, please post.

Thanks,

John

I'm using a varchar(10) field because some of the data in the field is garbage. If I could count on all of the records coming in from Foxpro to...

Yah, convert(varchar(10), field, 120) would have taken care of it. It'd just be nice if it would warn that the format would truncate data, or fail because of that,...

You can use ActiveX, but why not just use SQL?

I have to call it a night, but this should get you started.

--drop table _my_temp

declare @sql varchar(8000)

declare @sql2 varchar(8000)

set @sql =...

Michael's right. The index is the order in which the step is created, not executed.

You could include another column in your log;

objPkg.Steps(iCount).StartTime to find the exection order.

Just curious, why...

Good question... I'll ask our dba on Monday if nobody on here answers before then.

Thanks. I've needed an excuse to write a split like function. One of the handy things I miss from VB in T-SQL.

This function will return a table. You need...

Cool. Now that we uncovered the problem, make your life a little easier so you don't have to go through this next time. Create a procedure called, sp_runDTS...

Ok, what does the command line from the job look like? Do you have a /U and /P switch somewhere? The /P switch is the password stored in...

Kathi,

I can see why this would make you want to pull your hair out. Very important, don't forget to breathe.

Please try this. Change the owner of a job to...

DTS1 - fails when scheduled to run - login failed for SA - runs ok when fired manually. Who owns the job? How is the job executing the...

I think the easiest way to write this, and maintain the code going forward will be to use an IF statement and write the query three times.

If @fieldToSearch...

First off, why not do this?

select

A.id_account, sum(h.cTotalUSDValueAmt)

from

cdAccount A

join

cdiHolding H on a.id_Account = h.id_Account

group by

...

I recently added a procedure to the scripts section that should help you. DTS packages are stored on the server in msdb.dbo.sysdtspackages. You need to update both the...