Using SSIS, If I have a 50 byte char input field (flat file) and want to put it out to a 70 byte char output field (Flat file), I should be able to see the output field with 50 bytes of data with trailing spaces of 20 bytes but I don't. I know I can pad the field with additional spaces but I sure hoped that without padding it should have put the trailing spaces due to the length of the output field.
Question.
Hot Topic
- Import XML string into DB
- Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?
- SQL 2005 Developer edition fails during installation
- Variables in CONTAINSTABLE. IS IT POSSIBLE? NO ERRORS AND NO RESULTS.
- Programatically Evaluating SSIS Expression
- Cannot connect to Database in Server Management Studio
- DB Objects stored in VSS
- How do you export SQL 2005 Maintenance Plans?
- data mining
- Problem with logging/System::ErrorDescription variable
SQL Server
- Communication Link Failure - Error 08S01
- CREATE ASSEMBLY using assembly binary?!?!
- can we automate the data mining models management?
- Dynamic grouping
- Remove "top of report" when published via ASP call
- Viewing the report footer in layout view
- Long line of text error
- OLEDB question
- Getting the TXs on MIRROR
- Error while trying to make a remote connection to a named instance of SQL Server 2005
Question.
SS38
Have you tried adding a final field that has length 1 but nothing output to it. Maybe that will solve the problem.
Flat file parsing is a complex beast and many different systems handle your situation differently. As mentioned previously working with Biztalk on th esame issue you either find it works the way you want it or it doesn't, some you win some you loose and its a game of two halves :)