October 7, 2011 at 8:07 am
Hi
I am a noob using SSIS - how would I be able to specificy the column starting positions in my Flat File Connection Manager, example:
Column Starting Position 1: Employee Name
Column Starting Position 40: Employee Surname
Column Starting Position 92: Employee Birth Date
Hope it makes sense - Your help will be much appreciated.
Thank you
October 7, 2011 at 8:14 am
Take a look on SSIS Stairways. Maybe is good a way to begin if you are new to ssis 😉
October 7, 2011 at 8:16 am
thanks Pouliot, I did read the stairways SSIS topics and it helped me a lot, just struggling with the above - and so far my google hunt is not helping me to get a answer:-D
October 7, 2011 at 8:28 am
Create a flat file connection with a "fixed width", then specify each column by width. This allows you to mark out where each column is in the file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply