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 😛

Use a query as your source and do the CASTs in the query?

No need to apologise and the question was not stupid.

Feel free to post more questions as you work through.

You may be able to use a MULTICAST to achieve this.

Understandably. Does it always process exactly 44 rows? If so, can you try reading in the...