attribute date of type numeric to datetime...!

hi everyone..!!

how can I turn an attribute date of type numeric of a table and pass it to another table (using SSIS) as datetime

Can you provide an example of what those 'dates' look like?

/Kenneth

|||There is a special SSIS forum, you may be better using that. One way however would be to use CAST or CONVERT and create a view which converts the current date to correct format.|||

The 'trick' is usually, that if the 'date' is stored as a number, you must find out what the numbers represent. eg 12345 - is this seconds, minutes, hours? And counting from when?

Once you know the time-unit the numbers are using, and the starting point, you can use the datefunctions to do date arithmetics on the 'number'.

/Kenneth

Attn Microsoft : Incorrect Screenshot - SQL Server Integration Services (SSIS) Hands on Training

Hi All,

I am not sure if this is a correct forum to discuss on the document posted @. http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en on SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components.

I am assuming Microsoft Developers are constantly monitoring this forum.

In the document - SSIS Creating a Custom Transformation Component .doc on Page 2 -
Exercise 1 - Writing the no-op data flow transformation component -
Task 1 - Create a new C# Class Library Project

The textual description talks about creating a new Visual C# Class Library project in VS 2005 but the screenshot accompanying it shows the creation of new "Integration Service Project" in VS 2005.

Please change the screenshot appropriately to avoid confusions.

Thanks,
Loonysan

Thanks - we'll note this for when the samples are updated.

Attn Microsoft : Incorrect Screenshot - SQL Server Integration Services (SSIS) Hands on Trai

Hi All,

I am not sure if this is a correct forum to discuss on the document posted @. http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en on SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components.

I am assuming Microsoft Developers are constantly monitoring this forum.

In the document - SSIS Creating a Custom Transformation Component .doc on Page 2 -
Exercise 1 - Writing the no-op data flow transformation component -
Task 1 - Create a new C# Class Library Project

The textual description talks about creating a new Visual C# Class Library project in VS 2005 but the screenshot accompanying it shows the creation of new "Integration Service Project" in VS 2005.

Please change the screenshot appropriately to avoid confusions.

Thanks,
Loonysan

Thanks - we'll note this for when the samples are updated.