Ying Zhang

How to Handle NULL Values Loaded by SSIS from Excel Files

Using Script Task in SSIS to resolve problem of NULL values loaded from Excel.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(27)

You rated this post out of 5. Change rating

2008-04-28

27,876 reads

I’ve had a Dropbox account for years. Like a lot of people, I started...

Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...

Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...

Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111

Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241

Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros