dtsx

increasing dtsx column length

How can I increase the size of this column which welcomes the flat data from the text file? <outputColumn id="52" name="Column 0" description="" lineageId="52" precision="0" scale="0" length="999" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOpera...

How do I use a variable to branch in ssis ?

In SSIS how do I, 1) Pass a variable to the dtsx package. 2) How to use that variable to control branching to a particular data flow task. Thanks ...

SSIS 2005 - Export Data into an Excel 2007 Table

Hello ! I have an excel file (xlsx) containing a table : Once I launched my ssis task (successfully) to insert data in it, it is actually append after the table : My expected result: So I am looking for a way to insert into the table and expand it with the data. I hope someone could help me. Thank you ! ...