Hi,
I intend to import the data with an SSIS package, which would load the source file from a defined location.
Please bear with me as I am quite new to SQL, still loads to learn.
Thanks in advance,
Sure, no problem.
For SSIS, in the Flat File Connection Manager, you have an option that mentions Header rows to skip. On that option, you need to set it to 2 and check the Column names in the first row checkbox.
That should handle the file if the row delimiters are consistent.
Hi,
I intend to import the data with an SSIS package, which would load the source file from a defined location.
Please bear with me as I am quite new to SQL, still loads to learn.
Thanks in advance,
Sure, no problem.
For SSIS, in the Flat File Connection Manager, you have an option that mentions Header rows to skip. On that option, you need to set it to 2 and check the Column names in the first row checkbox.
That should handle the file if the row delimiters are consistent.
Hi,
I intend to import the data with an SSIS package, which would load the source file from a defined location.
Please bear with me as I am quite new to SQL, still loads to learn.
Thanks in advance,
Sure, no problem.
For SSIS, in the Flat File Connection Manager, you have an option that mentions Header rows to skip. On that option, you need to set it to 2 and check the Column names in the first row checkbox.
That should handle the file if the row delimiters are consistent.
Hi,
I intend to import the data with an SSIS package, which would load the source file from a defined location.
Please bear with me as I am quite new to SQL, still loads to learn.
Thanks in advance,
Sure, no problem.
For SSIS, in the Flat File Connection Manager, you have an option that mentions Header rows to skip. On that option, you need to set it to 2 and check the Column names in the first row checkbox.
That should handle the file if the row delimiters are consistent.
Hi,
I've done that but for some reason it starts at row 3, where it should start at row 1 and ignore row 2 and 3??
All help and Any help is appreciated
