June 28, 2012 at 11:56 am
Hello guys ,
There is any other way to create Header and headers detail in one file ?
Except This:
[http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2007/09/25/multi-record-formated-flat-file-with-ssis.aspx]
June 29, 2012 at 12:44 am
What's wrong with this solution?
SSIS before SQL Server 2012 isn't really flexible with flat files, so every line must have the same number of columns.
You could always do it with a script task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 29, 2012 at 2:30 am
3935 (6/28/2012)
Hello guys ,There is any other way to create Header and headers detail in one file ?
Except This:
[http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2007/09/25/multi-record-formated-flat-file-with-ssis.aspx]
Do you want dynamic headers/footers, or just some static text?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy