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...

rajiv.varma (4/28/2010)

---

You cannot view it directly in SSMS. I tried it, but no result. Only way to edit a package or view it is in BIDS or Visual Studio. If...

Wow, I just learnt a new technical term 😛