Viewing 15 posts - 1 through 15 (of 34 total)
Yea I actually posted something similar on the forums yesterday that I got resolved. Here is the code I had to use to get it to work properly.
UPDATE temp_ameriflex_detail
...
September 25, 2008 at 11:53 am
Yes that worked!
update temp_ameriflex_detail
set convert(varchar(10), cast(emp_doh as datetime), 112)
I took your code and edited it to fit my description. I am new at...
September 24, 2008 at 3:02 pm
When I run that code I get back 7 NULL fields. Is this where my problem is coming from?
The file I am importing has over 10k records so I couldn't...
September 24, 2008 at 2:51 pm
Something interesting I did find that works in an odd way is:
update temp_ameriflex_detail
set emp_doh = convert(char, getdate(), 112)
This works and sets all date to...
September 24, 2008 at 2:03 pm
Thank you again for the well written post.
When I run this code:
UPDATE temp_ameriflex_detail
SET emp_doh = convert(datetime,
...
September 24, 2008 at 1:02 pm
I have researched CHARINDEX some but I do not see how I could use it to my advantage in this situation. It appears to indicate what position where a char...
September 24, 2008 at 11:22 am
Thank you for the replies =D
The only problem I see is some of the dates I get are not set positions. For example:
9/3/2008
10/21/2008
I orginally did a substr but the dates...
September 24, 2008 at 10:46 am
Yes the table has already been made. I actually import data from excel into this table which is why I don't have the column as DATETIME originally because SSIS always...
September 24, 2008 at 10:18 am
UPDATE temp_ameriflex_detail
SET emp_doh = convert(datetime,emp_doh,112)
This gets the following error:
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting datetime from character string.
September 24, 2008 at 9:21 am
I am having a similar issue with my date formats. I have an excel file I am importing from that is MM/DD/YYYY format and I import into the database as...
September 24, 2008 at 8:34 am
I may have figured out the issue. I actually did anyway with the duplicate code for the parent table and put a SORT in the procedure that seems to have...
September 23, 2008 at 2:19 pm
I changed the Fail Component in the Lookup to Redirect Rows and now the lookup goes through correctly. The data is going into the tables but the foreign key column...
September 22, 2008 at 1:55 pm
I added a Data Viewer between Data Conversion and Lookup and the information is correct, I just don't know what is causing the problems on the lookup.
September 22, 2008 at 1:25 pm
VG (9/22/2008)
If you have ole db destination, then there is keep identity checkbox in editor. This will also copy the identity property from source. Why r you using datareader source...
September 22, 2008 at 1:05 pm
There shouldn't be an issue with int and numeric communicating should there? Just another idea to throw out there.
September 22, 2008 at 12:56 pm
Viewing 15 posts - 1 through 15 (of 34 total)