The result table should look like the attached pic.

Ya I figured that out. I tried this expression and it worked:

=iif(LEN(Fields!Weather.Value) = 0,"", LEFT(Fields!Weather.Value, LEN(iif(LEN(Fields!Weather.Value) = 0," ",Fields!Weather.Value))-1))

Thanks for your reply!

You need to click on Flat File Connection Manager Editor from the "Connection Managers" pane not the Flat File Source Editor.

Like you said, there is no "space" option for text qualifier. One option you can try is, read the data of all the columns in one column. For that you...

Thank you for that useful information!

It was the SQL Server machine.

The package was using Attunity Driver. The DBA had to install both 32 bit and 64 bit Attunity Drivers at his end. After that we were able to run the...

Thanks both of you for your replies. I will try running the packages with dtexec (32 bit version).

I recently purchased Microsoft Visual Basic 2010 Step by Step, by Michael Halvorson. According to the reviews, the book was supposed to be good. I havn't looked at the book...

You can certainly edit SSIS configuration file. For more information, please check this site: http://msdn.microsoft.com/en-us/library/cc895212.aspx%5B/url%5D

You can use Checkpoints. But a package can be restarted only at the control flow level. You cannot restart a package in the middle of a data flow. To avoid...

...Or you can use a third party component, Row Number Transformation. You can download it here: http://www.sqlis.com/sqlis/post/Row-Number-Transformation.aspx

Can you provide how your flat file data looks like?

Thanks.

I faced with a similar issue few weeks back. You need to use SORT for the child output and sort it by the Parent_Id. Then use MERGE JOIN to merge...