I suggest you try using the Export Column component. You will need to construct a single Derived Column of type Text containing the output rows + CR/LF delimiters, another Derived...

P.S. You will have to include the escape sequence for Carriage Return, Line Feed "\ r \ n" [no spaces - I have to include them or the sequence disappears...

You can use the Export Column component to do this. You will need to construct a single Text Derived Column containing the Comma-Separated values, and use the Number column...

You can use escape sequence literals within SSIS expressions - e.g. \'n' for New line, \r for Carriage return. [Ignore the quotes when coding in SSIS - I had to...

Hi Daniel,

Are you using SQL Server Standard edition ?  Per BOL "In SQL Server 2000 Enterprise Edition, the query optimizer will automatically consider the indexed view. To use an indexed...

Since the copy is working fine when run on it's own, or when run manually from the main package, the first place I would be looking is the global variables...

Not sure if it is the whole problem but it looks like you are not passing the parameters to dtsrun correctly.  The correct syntax is:

/A global_variable_name:typeid=value [where typeid = 8...

There is a list of DTS documentation products and other useful DTS tools at http://www.sqldts.com/default.aspx?401

You still have a potential problem with the Global Variable setting - hence your instruction:

' **** IMPORTANT ****

' Before promoting a DTS from DEV to any other environment you MUST...

Try DTSGlobalVariables.Parent.Connections("[Put the Connection Name here]").ConnectionProperties("[Put the Property Name Here]").Value

I think this is what you are looking for

There is a possible solution in the Forum article entitled

DTS error when attempting to import from MS Access into SQL Server

posted 10/5/2005

by "Chris":

as a workaround, I took the...

You could also try avoiding the update altogether by importing your SAS data into a staging table, then having a second transformation that inserts the joined data into Claimdata i.e...