Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSIS basics, flat file questions

Posted on 2013-10-22
7
Medium Priority
?
391 Views
Last Modified: 2016-02-11
I understand the basics on SSIS but trying to understand some nuances . . .

my task is simple - read a flat file with one column, right-trim the data, and append " } " to end of record. I've already done this successfully but have a few questions to better understand SSIS.

My flat file has a record size of 103 chars, but with spaces at the end it's 133.

When I point to this file in SSIS for a data connection, it can see the file ok (1 column), but in the Advanced tab it says "OutputColumnWidth = 50" (and InputColumnWidth = 0)
flat-file-connection.png
- why doesn't it "see" that the file size is 103 (or 133) ? I guess 50 is the default no matter what ?

- I don't understand having both "InputColumnWidth" and "OutputColumnWidth" . I just ignored "InputColumnWidth" and got my task completed.
0
Comment
Question by:Alaska Cowboy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 66

Assisted Solution

by:Jim Horn
Jim Horn earned 1000 total points
ID: 39592045
>read a flat file with one column, right-trim the data, and append " } " to end of record.
In between your source and destination, add a Derived column task, replacing existing column, with an expression that goes like this:

TRIM(ColumnName) + "}"

Open in new window

0
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1000 total points
ID: 39592139
>why doesn't it "see" that the file size is 103 (or 133)
Don't know, but make sure you have the file format and Header row delimeter correct.

>I guess 50 is the default no matter what ?
Correct.
0
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 39592143
Jim, ok, thanks, I'm getting beyond the beginner phase . . .
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 39593869
Jim, what about this:

>>- I don't understand having both "InputColumnWidth" and "OutputColumnWidth" . I just ignored "InputColumnWidth" and got my task completed.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 39593878
Don't know about that one.  I've noticed that it's set when you do a fixed with / ragged right, and usually the same values.
0
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 39593977
Ok, I'll just keep my eyes on it to see how it's handled in different cases.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 39594016
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question