Try it like this:

DECLARE @Param0 datetime;

DECLARE @Param1 datetime;

SET @Param0 = ?;

SET @Param1 = ?;

SELECT DISTINCT * FROM

(SELECT DISTINCT * FROM [Forward_Mar&Apr2012]

WHERE [Valuation Process Date DD]=DATEADD(DD,-1,@Param0))A

JOIN

(SELECT DISTINCT * FROM [Forward_Mar&Apr2012]

WHERE [Valuation...

The table is called dbo.sysssislog.

If it's not created in the database, take a look at the system tables, it may have ended up there.

Rock from VbCity (7/1/2012)

---

Please take a look at the ExecutionLog view; there are 3 views depending on the version of MS SQL you are using; this is the MSDN article,...

I suggest hiring a consultant.

Or at least following some courses about database design and read some books about the subject.

Easy one for a Monday, thanks Steve!

What is the expression that you used?

What's wrong with this solution?

SSIS before SQL Server 2012 isn't really flexible with flat files, so every line must have the same number of columns.

You could always do it with...

The dataflow will only finish if every component in the dataflow has finished. In other words, when every parallel path has finished. So you're good, just connect the Execute SQL...

You'll need to use a derived column to convert the strings to an actual datetime value.

You can check first if there string value is blank and if it is, replace...

Ron's series on transactions led me to believe it should be 2. 🙂

Got it wrong, but definately learned something. Good question!

(3 wrong in a row, this is not a good...

There's no such thing as too many records. As long as you don't have blocking components (sort component, aggregate component for example) you can read as many rows as you...

What have you tried so far?

I don't understand the issue. If you import it as fixed width, what's not working?

Nice alternative solution. However, if processing fails midway, you have to start all over again.

opc.three (6/27/2012)

---

If it were me I would not take the advice of anyone on a forum for this one. If you have a dev environment, try it there first and...