Is DateStamp a column name in emDetail?

If so, your syntax is going to be more like this:

update dbo.emDetail

set dateYear = DATEPART('year',datestamp)

Remember single quotes for literals in T-SQL.

To update existing data, you need to use an OLEDB Command transformation. The various different Destination components are for INSERTs only.

Other than "can someone help me", there is no question in your post, it's just a statement about what you're doing.

I think I may have misunderstood your requirement. Are you trying to UPDATE records which are already on the database, rather than doing an INSERT?

You say 'thanks in advance', but all you've done is told us what you are trying to do, without asking for anything. Which part, specifically, would you like help with?

If you double click on your destination in your dataflow and select Mappings, you should see the new derived column as an available input column - just change the mapping...

I'd be tempted to heed the error message and give the column a name:

SELECT '00' + CONVERT(VARCHAR(8),GETDATE(),112)+

' WEEKLY DATA FEED'+

REPLICATE(' ', 190) Col1

--etc etc

The word 'here' in my previous post is a hyperlink.

Good old Excel. First place to start might be with IMEX=1 in your connection string. See here for more info.

Bravo!

RonKyle (1/12/2010)

---

I would appreciate more details. I have tried to use a variable both in a sql statement in the sqlcommand property and even created an entire sql statement...

You cannot. There is no data pipeline at the control flow level, so a conditional split has no context in which to run.

What are you trying to do?

As SSIS is largely meta-data driven and you are not able to provide this meta-data - because it is not known in advance - you will find it difficult (now...

Yes it does. Give it a try and see how you get on.

In your example, there is no tab after char1, the 'code', yet the rest of the data has tabs delimiting the fields. So it's really not clear - it looks...