I need to generate the Sequence Number from both combined data; if I use "n" value from the order by,

then I get for example: 1,2,3,4 from split data and then...

Thanks Luis for the posting of both combinations.....that is great!! Just what I needed.

Thanks for Jeff Modine splitter.

I am always learning new things!!

I was able to use Jeff Moden's splitter at http://www.sqlservercentral.com/articles/Tally+Table/72993/

and use CHAR(10) as the delimiter, and the results are not all bunched up; but I can still end...

CREATE TABLE [dbo].[tableA](

[CUST] [varchar](9) NOT NULL,

[WPTEXT] [varchar](4000) NULL)

INSERT INTO tableA values ('12345' ,

'6/26/08 BAD DEBT 1,351.28 BANKRUPT C-11' + CHAR(10) +

'07/03/08 BAD DEBT RECOVERY 273.07 BAL OWED 1,078.21.' + CHAR(10)...

So I was able to split column based on specific substring length and export the data to my target source; at which point I noticed data contained Line Feed.

So is...

on side note....how do you post the script inside the window box. I read best practice for posting but not seeing it.

Do you use the IFCode Shortcuts...still not quite...

The Tally Table appears to be what I am looking to do.

I will verify some of the results but initial return values look okay.

So the code has several...

Thanks Chris again for you investigation and posting your results...I am sure it will help anyone doing this. I know I will refer to this when I have to...

I was fortunate to have my Prod server also run Crystal Report Server. Maybe you can install just the Cystal Report Viewer?

Glad this post help get you started...and I appreciate the feed back and your posting of your results....I am sure it will help me and others.

Nice job investigating passing parms...

so I found this topic and now I have ssis working....trick is to use data reader

AS400 - SSIS Issue Resolved.

I tried to build a connection between iSeries (as400) and SQL...

status update...I was able to restore the project from tape backup to another location; and was able to open the packages (had to correct the connections)...but have them working again....

try installing Crystal Report Framework For .Net 2.0

C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports\CRRedist2005_x86.msi

If not found, google it and download it.

see if this helps

I copied the four crystal reports dll files into both "C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies" and "C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies" as that is what I have. I just checked my...

The first thing you have to do is copy the four crystal reports dll files into the sql server folder so they can be added in the ssis script reference;...