December 5, 2011 at 12:11 am
I just added a new column, called BusinessOnwer, to an excel source so that I could give it a default value and then map it to an existing varchar (15) column on the SQL destination called BusinessOwner. The package executes without error but nothing populates the destination table.
Flow is: Excel Source->Derived Column->Data Conversion->OLE DB Connection.
Inside the derived column data flow object I added the conditional statement
ISNULL(BusinessOwner) ? "myalias" : BusinessOwner.
with the expectation that it will put my alias in the destination column for every BusinessRow row that is empty.
In data converstion data flow object I specify string [DT_STR] 15 as data type to match the varchar(15) on destination.
Like I said, no SSIS errors are returned running the pkg but nothing populates the BusOwner column on the destination table, either. I don't know where to begin troubleshooting!
December 5, 2011 at 6:04 am
It is better to stick with one thread, instead of posting your question in various threads. That way replies will get fragmented and it can waste people's time.
Question with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic363612-147-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 9:33 am
OK.:blush:
December 5, 2011 at 12:03 pm
conclusion to problem: I believed that OLE Destination output was overwriting destination table, but it was not. Once I truncated the destination table I saw that the import went smoothly and the BusinessOwner column populated. Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply