Thank you Sean! This is indeed a good starting point for a novice like me. 🙂

Thats strange. Can you look at the windows event log and see whats going on there at the same time? There should be HUP signal from some other process for...

Do you see any kind of error message? If you have the exact error message, post it here and someone should be able to help you.

Are you looking to write a query instead of the management studio right click version?

Can I use OPENROWSET (and ROWSET functions in general) to over come this issue?

Howard,

I already tried doing that. But this ODBC driver doesn't seem to handle that too.

What I am thinking is that when ODBC establishes the connection, it expects to see...

I would agree to the fact that we can always use the derived column to change the data. But the problem is, the package fails at the ADO.NET/OLEDB source itself...

This doesnt help either. The ODBC driver for UniVerse does not allow specifying any other SQL functions except SELECT. So in effect, all I can write is SELECT ColumnA, ColumnB,...

I got the solution. While creating the code, I had thought that I would be replacing the single quotes as well with a set statement. But that was not the...

My bad..I didnt even mention that.

It says "Incorrect syntax near ')' ".

I am using Print statements to weed out what's going wrong.

Create a variable of string type and set its value as the following:

(DT_STR, 4, 1252)DATEPART("yyyy", @[System::ContainerStartTime]) +

RIGHT("0" + (DT_STR, 2, 1252)DATEPART("mm", @[System::ContainerStartTime]), 2) +

RIGHT("0" + (DT_STR, 2, 1252)DATEPART("dd",...

I agree that it will not give you the entire date. But some manipulation and concatenation can get you there. Though it might not be optimal, it will get the...

Thanks for your inputs! It helped me a lot:-)

The magic word is DATEPART my friend. Use it 😀

try something like this.

I have intentionally not written the update code. I guess you can figure that out on your own 😎

create table #orders_delivered_sta

(

#orders_delivered_sta_id int primary...