May 18, 2009 at 4:21 pm
i am trying to create a new SSIS. this SSIS will take file which contains the record is tilde delimited, the fields are also fixed length
Please suggest me what option to select fixed length or delimited
May 19, 2009 at 12:04 am
Hello,
Are the lengths of any of the fields likely to change? If so, you would then have to redefine your Fixed Length file definition. So may be Delimited would be the better option.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 19, 2009 at 12:40 am
Frankly, delimited is a heck of a lot easier to deal with in SSIS.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 19, 2009 at 12:48 am
I'd recommend using delimited format instead of fixed length formats, as it is a lot easier to work with.
--Ramesh
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply