CozyRoc (12/16/2009)

With arguments like this, many people would ask why MS wasted all these resources and time to create SSIS.

Here is my opinion about the custom .NET code PROS you...

Hi,

If I understand properly - you dont mean what langauge to use in SSIS but rather whether to go with pure .NET vs SSIS. Am I correct.

We are...

thanks for this - much appreciated. reading now 🙂

thanks aleksandar.kostovski & jgrubb.

Creating and usign a secure connection i.e. Using a TCP port tunnel/VPN ssh port tunnel to secure a connection is now not an option (although probably the...

Hi,

Im interested in how the 2 dbs would be configured to communicate with each other securely.

For this to be a secure connection - the remote oracle db would...

Hi kshitij,

thanks for this. can you please provide a brief overview of how this is done (architecture).

Does the remote oracle db connect to the sql server over...

thats great. should have thought about that one a bit more.

Thanks

thanks sushila and rgR'us. Thats what I was after.

Great. Thanks.

Just find if there are upper case letters i.e. return a 1(true) or (0)false would be ideal - for all entries within the field. I could then adapt it at...

Hi,

I thought this would count the number of uppercase letters in a field but counts lowercase letters too. Any suggestions?

create function dbo.find_uppercase1

(@name as varchar(255))

Returns varchar(255)

as

BEGIN

declare @current varchar(1)

declare