November 29, 2017 at 7:47 am
jaryszek - Wednesday, November 29, 2017 7:41 AMThank you Guys,i used :
Select
*,
CAST(Company_NIP as float) as Company_NIP2
FROM QlikView.dbo.tbl_Slownikand there is NO any problems within this.
I am shocked. Wow!Thank you!
I am closing the topic but still not know why this was not working in SSIS...Jacek
You are welcome!
😎
BTW, he he, SSIS "works" in misterious ways :w00t:
December 1, 2017 at 8:35 am
The original problem is caused by removal of the column definition to the left of Data_Zmiany. The column names presented when a file contains a header row and the "Column names in the first data row" is checked are only to help identify the field contents. I often rename them to the destination table column names which makes mapping from the data file to the database table automatic. When the rows following the header row are loaded, the relative position of the name is what is important. In this case anything in the second delimited column of the input file should be identified as Data_Zmiany. If only interested in the Data_Zmiany field then two columns must be identified - the UniqueID and Data_Zmiany which identifies Data_Zmiany as the contents of the second delimited field of each row. These fields could be called anything - IgnoreMe1 and Col2 - it does not matter.
If you really wish to remove the first column from appearing in the following steps in the Data Flow, right click on the Flat File Source object and select "Show Advanced Editor...", select "Input and Output Properties", expand "Flat File Source Output" and "Output Columns", select each column that will not be used and click on Remove. This only eliminates the column from the output of the Flat File Source but not the column definition in the connection manager.
Note that for a data file containing multiple delimited columns creating only one column name automatically turns off the column delimiter so all data in a row including the column delimiter will appear in the defined column (Visual Studio 2017). If only the first column was required two columns would still have to be defined.
I find SSIS to be very useful and have used it to load billions of rows of data. For complex editing I add a Script Component C# routine.
December 4, 2017 at 3:33 am
Hi Dennis,
thank you for your precious answer !
It is working like a charm.
Problem was also connected with nulls in my database within float field.
I bypass the problem replacing nulls with 0 in QlikView...
Warm Regards,
Jacek Antek
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply