April 27, 2011 at 5:20 pm
Hi,
I am new to SQL Server.
I have a .csv file that I wish to import. I am using the SSIS for importing the file as I have to schedule a job for the same in future.
This is a file that I will be receiving from some external source. Now, this file has a peculiar problem which I am unable to solve. Please refer to the file attached for details.
In this file, the Dest Zip field is NULL. When I try to add this file to the Flat file source in the Dataflow task, SSIS is automatically taking the next field's value in the Dest Zip field instead of keeping this field NULL.
Can anyone please help me out by telling how should I keep this field null because I am expecting that the files that I receive in future will contain data in this field.
🙁 ITS REALLY URGENT !!!! PLEASE REPLY SOON !!!! 🙁
April 28, 2011 at 11:27 am
siddhanttalwar (4/27/2011)
Hi,I am new to SQL Server.
I have a .csv file that I wish to import. I am using the SSIS for importing the file as I have to schedule a job for the same in future.
This is a file that I will be receiving from some external source. Now, this file has a peculiar problem which I am unable to solve. Please refer to the file attached for details.
In this file, the Dest Zip field is NULL. When I try to add this file to the Flat file source in the Dataflow task, SSIS is automatically taking the next field's value in the Dest Zip field instead of keeping this field NULL.
Can anyone please help me out by telling how should I keep this field null because I am expecting that the files that I receive in future will contain data in this field.
🙁 ITS REALLY URGENT !!!! PLEASE REPLY SOON !!!! 🙁
I think you just need to include header which is column names and add both definition and data types in the file connection manager under Advanced options. SQL Server may error out if you did not use you delimiter to do null padding. That is if the column is null you must add comma or Pipe or Tab to show there is a null value at that location. Post again if you still need help.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply