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

Check the source data in row 45. There must be something 'different' in it which is causing the error...

To have figured all of that out based on the hint is impressive, as is posting back your solution so thoroughly. Good stuff.

Now I shall go and read about the...

Maybe you could just create a VIEW and use that as your source?