That works .. Thank you..

Best Regards

THNQDigital

but can we use isnumeric inside a stored procedure..?

Create Proc test..

as

IF (LEN(@SerialNum) = 10)

  SET @AgeYear = LEFT(@SerialNum,2)

  IF (ISNUMERIC(@AgeYear))

  BEGIN

   .........etc

i get error saying incorrect syntax near ISNUMERIC.. i know books online lists...

If you have the VS.NET loaded ( I have MS.NET Framework1.1)

Open MS.NET , Goto Tools Menu..ConnectToDatabase.. Provide necessary Connection details.. after you comlpete this step..

Under ServerExplorer properties window.. you will...

Please refer below link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_backcomp2_63w9.asp

You could use many performance counters via System Monitor to understand how your query/server is doing.. you will get a lot of information about this in...

Hi,

have you considered usign Execute process task in DTS ? This has a return code. and inside a batchfile ( you write bcp statement inside) you can return 0(success) or...

Hi Steve,

Thanks.. for now i managed using the carriage return char

" -r  \r\n" as the row delemeter .. now the entire column values even though same column spans across multiple lines...

Hi Phill,

I found the issue.. If i use 2 connection objects one for creating objects and another for loading tables inside the package (p2).. Things work fine.. If i use the...

Thank you guys.. for all the help

THNQdigital

Hi Roy,

Thanks for your time.. i tried your code..

Inside Package P2

oPackage.LoadFromSQLServer  "","","",DTSSQLStgFlag_UseTrustedConnection,"","","","P1"

for each objStep in oPackage.Steps

  if objStep.Description = "Sendmails" then

   objStep.Execute

  end if

next

Calling Package executes successfully but does not...

Hi Guys,

I tried following

make an excel sheet with below values

Server1.xls

Serialnumber     Sitename

1234                0010 ( formatted as text)

1235                0020

1236                0030

1237                3001

1238                3002 ( formatted as general)

1239               0040

now only site names starting with 00...

Hi AJ,

Yes, all the sitename are populated.. I actually figured out the problem.. but not sure how would i be able to overcome this one..

here is what is happenning..

as per...

Hi Balaji,

Have another step after your copy step is over ,You could use a activex script ( use file system object) to check if the file you are trying to...

Hey Phill.. you are the man.. thanks.. that was the problem.. i was only deleting the data not the rows in excel.. Thanks..

Thank you Howard for the informative URL..

I have...

Thank you all for your time.. For now i will stick to the methods i described, will certainly have to edit the connection properties in the destinations server as rightly...

Hi,

Thanks for the help.. Upon exception i was inserting exception then call, goto Processnext 

Processnext : ROLLBACK TRAN

Like you said " upon exception,I have to call ROLLBACK TRAN first then...