http://msdn2.microsoft.com/en-us/library/ms162810.aspx

Scroll down to /Set propertyPath;value

They are stored as smalldatetime in the table after SSIS processing.

But when they come in from flat file source i have to store them in string(DT_STR) in order to successfully convert...

FINALLY!!!

Lynn i changed those columns to (DT_STR) in the flat file source and then added derived column tool.

I got it to work by using a derived column transformation tool and by adding

(DT_DBDATE)(SUBSTRING([TranDate],1,4)...

Lynn

I get the same error.

[TollLog [65]] Error: Data conversion failed. The data conversion for column "TransactionDate" returned status value 2 and status text "The value could not be converted because...

JLK thanks for the response.

Actually it was the Data Access Mode in OLE DB Destination

Mine was set to "Fast Load" method (Bulk Load) which ignores Defaults.

When i changed it to...

I get the same error when i try using the regular lookup.

There is something definetly wrong with SSIS.

Both of my tables have the same datatypes.

Thank You Leonce

That worked but then i ran into another error "Access to data path denied".

Finally after some reading i found out.

When i share any folder "\Server1\Test"

I have to remove everyone from...

Jason thanks for solving it.

nope just another media company

Yeah the report is huge it contains Email Addresses and contest info from all of our websites.

1. There are 20 mil records and i'm only showing 5 mil.

2. And there are 120 columns i'm only selecting 35.

Yes it's dev ...in live i'll have to show all 20...

I get the same timeout error when i try to open a view (right click -->open view) that returns over 5 mil records.

But after Adrians comment it's all good.

Thanks Adrian

I figured it out.

I was using modify table ---->(manage keys-indexes) window to create indexes instead of right clicking indexes under tables.

Thanks

Because of previous manual removal of clustered sql server 2000

we decided to reformat the nodes and reinstall everything from scratch.

When we installed sql server 2005 on a cluster we...

This is what i see in the error log of sql server.

I still can't start sql server from cnfogi manager or bring online from cluster admin.

2006-10-17 13:10:19.44 Server      Error: 26054,...