Yes/

Any scoop on this?

thanks for your mail. When I DTS it, it should become -1.20 OR -1.30 insread of being skipped.

varchar(25)

this data is coming to an import table. From there, it is validated and sent to the real table.

In real table, the data type is money.

Happy Independence Day to America..... a beautiful country on the planet.....

I became a US Citizen as of 4th July and it's a great privilege to be.

I agree with Andrew Murphy. This is absolute 'SPAM' where this site is being maintained to delve deep into SQL Server and its releavant topic. There are many articles that...

Hi Sugesh,

How do I make a dll of SSIS package ? Is installing different than deploying? I am confused here. Can you please guide? Which one is better?

thx,

Ram

Thanks Padmaja!

Ms. Padmaja!

First of all, an exemplary topic.

As you mentioned, I would like to use  other approach that is to use the API to create, configure and run packages from own...

Mr. & Mrs. Jones,

WISH   YOU   A    H A P P Y  A N N I V E R S A R Y!!!!!!!!!!!!!!!!

\(.|.)/.........

CREATE FUNCTION dbo.fnTest (@RunDate datetime)

RETURNS @retTable TABLE

(

 col1 int,

 col2 varchar(10),

 col3 varchar(40),

 ..

 ..

 ..

 ..

)

AS

--

Begin

 INSERT INTO @retTable(col1, col2, col3,..)

 SELECT val1, val2, val3,..

   FROM table1

--

 RETURN

END

Hope this helps.....

SELECT *

  FROM msdb.dbo.sysjobs

-- Swamy Ramaswamy

you can try this... c1, c2, c3 are columns.....

SELECT c1, c2, c3

   FROM table

 WHERE PATINDEX('%[a-z0-9]%', c1)

   BETWEEN PATINDEX('%[a-z0-9]%', c2)

           AND PATINDEX('%[a-z0-9]%',c9)

Hope this works.....

samrit

you can try this... c1, c2, c3 are columns.....

SELECT c1, c2, c3

   FROM table

 WHERE PATINDEX('%[a-z0-9]%', c1)

   BETWEEN PATINDEX('%[a-z0-9]%', c2)

           AND PATINDEX('%[a-z0-9]%',c9)

Hope this works.....

samrit

Mr. Jambu Krishnamurthy!

Excellent article.

Regards,

Ramaswamy