December 6, 2011 at 3:43 am
Hi all
I'm fairly new to SSIS, and so far have been able to work out all the tasks I need to perform. But this one has stumped me, so I'd be grateful for help.
I have a flat file connection manager, an OLE DB source that runs a T-SQL query, and a flat file destination, using the connection manager. All works fine, however I need to make changes to one of the columns that's being output. It contains a fixed character string, and I have changed that string to a new value that's longer than the original. As a result, I get the warning message appear on the OLE DB source about possible truncation occurring, which I understand. However....
... when I open the connection manager and go to the Advanced tab, where I would expect to be able to modify the columns, the "Data Type" field in the right-hand box is black, and I cannot modify it. PLEASE tell me there's a way to do this without having to completely recreate the connection manager and destination from scratch!! This is driving me mad...
Jules
December 6, 2011 at 3:14 pm
Are you referring to the connection manager for the Flat File or for the OLE DB?
The OLE DB Connection Manager doesn't have an Advanced tab with Data Types, so I assume you're mistakenly looking at the OLE DB *source*, and trying to modify the Data Types.
If you want to change the data types of the OLE DB source, you'll need to modify the query that is feeding it. Otherwise you're going to get metadata inconsistency and data type errors.
If you're talking about the Flat File connection manager, then you should be able to modify the data types no problem.
December 12, 2011 at 9:32 am
kramaswamy (12/6/2011)
Are you referring to the connection manager for the Flat File or for the OLE DB?
I'm referring to the flat file connection manager, which defines the output file receiving the results of the OLE DB query.
I've been working on something else for the last few days so haven't looked at this issue. Now I've just got back to it, opened the flat file editor dialog box and would you believe it, the issue isn't there!!
As I said previously, on the "Advanced" tab of the Flat File Connection Manager Editor window, the box that shows the current value of the "DataType" property was totally black, so I couldn't even see what the current data type was, let alone change it. If I clicked on it, the dialog box closed. That was true for every column, so I was unable to change any of them. Now, bizarrely, the data type shows up perfectly fine, and I have been able to update them.
So.... the problem has gone away for the time being, but I'm concerned as to why it may have occurred, and what I would do about it in future if it happens again. Anyone else come across the same odd behaviour?
December 12, 2011 at 9:37 am
Never seen that problem occur :/ Sorry
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply