Thanks Christopher, unfortunately that is not working I need to find a back door into this file... it appears that either the file is corrupted or when trying to open...

Here is how I was able to address the issue that I was having. I ended up creating a sproc that altered another sproc.

1. sproc:

CREATE procedure prAlterprRecCount @vTbl varchar(25) as

declare...

Thanks guy's this information is much needed

thanks for the input Frank I will take a look at the execution plan of both alternatives.

Steve Johnson

I found the problem..... there was a carriage return at the end of each slspsn2's name....not sure how it got there..... I removed the return and all is well....

Thanks guy's

Steve...

yes the 4 values that I am looking for are ('FSALBY','FSKENT','FSAURO','FSRAIN')

Steve Johnson

I have tried this statement to see what I get and nothing is returning???? I went to the table and select the 'FSAURO' straight out of the table, I know...

I suspected that I would need to us VB or JAVA to pull the data in but wasn't sure....

Steve Johnson

It is setup to use On Success of the Task

Steve Johnson

Thanks... I looked all over yesterday for this and couldn't find it....

Steve Johnson

Antares686 I will take you up on your offer... I need the O'Hare functionality

Thanks

Steve Johnson

select upper(substring(col,1,1)) + substring( col,2) this will work for what I need. Thanks guys....

Steve

Steve Johnson

thanks guys, I got it to work...

Steve Johnson

Thanks Guy's you have been a big help

Steve Johnson

Is it possible to save a DTS to the server using a script??

Steve Johnson