Why aren't you using a default value on the field?

[font="Courier New"]CREATE TABLE tmp (Name VARCHAR(10) NOT NULL DEFAULT(''), Location VARCHAR(10))

GO

CREATE VIEW Sample1 AS

SELECT * FROM tmp

GO

INSERT tmp (Location) VALUES ('My...

yes

And that ties us back to the original thread topic - those people are probably the ones that have been recently posting on this site...

You cannot set a row to be null, you can set all of the field values in the row to null. Each field has a Value property and a...

Write the parameter values to a table.

Jeff typed that very sarcastically - although I am sure he presses the keys differently (and probably hunches a bit) when he is joking, it sometimes does not show up...

point taken.

I was thinking the same thing just after I posted. I figured I would leave later.

Also, we currently have no evidence that Lynn has ever run anyone over.

Are you supposed to do something with the records, or just log an error somewhere? Should the package fail, or continue?

You have a couple of options.

On the pure SSIS end - you will need to use a script data flow component. This will allow you to take the input...

IIF evaluates both sides of the expression, so it is failing on the conversion to currency.

I think you could use a REPLACE to remove the slashes in the currency conversion....

That happens to me too. How big is your project? BIDS seems to do that what my machine starts running low on memory. It happens primarily when...

Just to be safe, I'll walk.

Use a UNC path and share a folder on your machine so the server can see it.

The optimizer is usually pretty good. Where it tends to have most failures is in getting bad information. Make sure the statistics are updated on your production table...