interesting question!

Bang on!!!

Thanks for your timely help 🙂

Yeah, you are right!

Thanks for the reply Dan...

But i don' want to ignore below rows as they hav only ONE 0 & 9

12345680

45690459

a9s156f4

sd59fs94

s4d06s2d0

sd6540

I want to ignore these only...

insert into @sample (string) values('00000')

insert...

Generally, SPs need to be given EXEC permission for those who need to run the SPs.

For this, permission will be provided after creating / altering the SPs like

GRANT EXEC on...

As per general Industry standards, Programmer (DEV team) will have only READ access to System Testing / UAT / PROD / DR Servers.

DBA & Release Management team should be contacted...

Plz give the complete & correct details of your requirement.

Not sure what you are expecting by saying "Copy primary key from one table to another"...

Cheers,

Suresh

Tom,

# (temp) tables will be stored in TempDB database & will be Alive for the current session (SPID) only. Once you close the session, it will be dropped from the...

Hey Jack,

Thanks for your response.

The problem has been resolved now. It's due to lower version of DB2 provider. I got DB2 ver 9.1 provider installed & it's working fine 🙂

Seems to be Teradata provider error & got it resolved by re-installing it.

Thanks for the response.

I need to do this via SSIS 2005.