June 23, 2009 at 8:35 am
How can I change the default length of DT_Str from 50 when setting up a flat file source
June 23, 2009 at 8:55 am
p.s. not on the fly but as a default for each new source
June 23, 2009 at 3:51 pm
Hi,
I don't know how to override the default behavior. Maybe the BIDS Helpder can help you with the feature "fixed width columns".
http://bidshelper.codeplex.com/Wiki/View.aspx?title=Create%20Fixed%20Width%20Columns
-----------------------
SQL Server Database Copy Tool at Codeplex
June 23, 2009 at 11:04 pm
Right click on the connection manager and select Edit. The Flat File Connection Manager Editor will open, then select Advanced in the left hand pane. This will list the columns in the connection. Click on the column you want to change and set the OutputColumnWidth value.
If you already have a flat file source in your data flow that uses that connection you will have to refresh the metadata. Just double click on the flat file source and you should get a message about the metadata being out of sync and there should be an option to automatically apply changes.
June 23, 2009 at 11:15 pm
Eric Klovning (6/23/2009)
Right click on the connection manager and select Edit. The Flat File Connection Manager Editor will open, then select Advanced in the left hand pane. This will list the columns in the connection. Click on the column you want to change and set the OutputColumnWidth value.If you already have a flat file source in your data flow that uses that connection you will have to refresh the metadata. Just double click on the flat file source and you should get a message about the metadata being out of sync and there should be an option to automatically apply changes.
That does not change the default, just the specific one you are editing.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 2, 2012 at 2:16 am
Does anyone know the answer to this? How to change the default value of the column width say from the current 50 to 250?
April 2, 2012 at 2:27 am
Have a look in Tools / Options / Database Tools / Table and Database Designers / Column Options in BIDS.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 2, 2012 at 2:30 am
Got it. Thanks.
April 2, 2012 at 2:33 am
I'm not sure exactly what those settings affect, but worth a try 🙂
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 2, 2012 at 3:00 am
Unfortunately, Changing the settings did not work.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply