In the part where you specify what the field will contain, just add some literal text as your expression, eg

"Server1"

This will then be available to you in the data pipeline,...

Hey, you're not that new! I told you how to add derived columns yesterday - see here

http://www.sqlservercentral.com/Forums/Topic912502-148-1.aspx

Phil

Have you tried debugging the Script Task to see whether that gives you any clues about what is happening?

So what do Email_Start and Email_Success do?

Surely your e-mail task needs to be outside of the Sequence container, after the Collect All Errors task?

Great stuff - glad to help & thanks for posting back.

Or derive a string in the universal format YYYY-MM-DD hh:mm:ss and just pump that straight into your SQL date field.

When you double-click on a dataflow transformation, a new window opens. In this window, you will see boxes representing your source and target.

Drag a Derived Column transformation on to this...

🙂 no problem. Put this between your source and destination, as part of the dataflow.

Here's your Derived Column formula:

SUBSTRING([Column 1],7,4) + "-" + SUBSTRING([Column 1],1,2) + "-" + SUBSTRING([Column 1],4,2) + SUBSTRING([Column 1],11,13)

This will create a new column with data type Unicode String. You...

Yes there is. You can fire the date into a derived column transformation where you can add a new column which 'derives' a proper date from your date text.

What format...

What is the source of your data?

We need to understand a bit more about the logical flow of your package, I think.

You can easily check out your Script Main suspicion - just try changing it to...

There was a suggestion earlier in the thread that you just run the job frequently - every 5 minutes maybe - and process a file if it exists, otherwise exit....

Welsh Corgi (4/28/2010)

---

Elliot,

I did not believe that what I wanted to do could be accomplished.

Thank very much for you replies.

But did you have so say the period comment?

"This means that...