I agree with above also if it is always the 15th file you can edit your loop to pick up that specific file name. I would guess that the...

Correct sql is

select * from tempdb..sysobjects where name like '%#testvm%'

ISNULL and COALESCE though equivalent, can behave differently. An expression involving ISNULL with non-null parameters is considered to be NOT NULL, while expressions involving COALESCE with non-null parameters is considered...

Are the images not showing up for anyone else?

Even when I right click and say Show Picture nothing happens.

Good Article. Two suggestions

I would make the attribute appear in the same code window as the method. At first it looks confusing because you have

<Microsoft.SqlServer.Server.SqlProcedure()>...

Good question but I think a better explaination is:

the default of decimal without parameters is (18,0) thus making 1.09 -> 1 and then the ceiling of 1 is 1

This is absured and I will use the same logic Hugo used on the question about creating a table with []... How does the deception in this question help in...

UMG Developer (9/28/2010)

---

I agree, nice question, but it would have been even better with a fourth option: 1-Boston;2-New Delhi

Without that option it was really a test of transactions, not...

This is how we get the date for the current day without time element

DECLARE @a INT

DECLARE @b-2 DATETIME

set @b-2 = GETDATE()-.5

SET @a...

Thank you for the question and the detailed explaination

It sounds like you are going to have to have a script task in your loop to determine which file you have. You can then set a variable and...

You're right, sorry to lead you astray

To answer your original question after I added the reference

Microsoft.SqlServer.DTSRuntimeWrap

I was able to type the imports statement

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Now what you can do with...

I do not see why you need a reference for that. Note that for DataFlow Script Task it is already included.

What I would try is create two variables...