I've found a solution which works perfectly without using a TEMP or Staging table. It is a bit complex but works very well and is very adaptable for future changes.

Here...

Well here it is! Script Task success! I hope this script may help someone else using MYOB Order imports.

FYI, I am recently new to SSIS and don't claim to be...

Phil, point taken. Therefore i'll put the feelers out there to anyone who may have an SQL based solution?

Once i get this script worked out i'll post it up to...

We already attempted to create the line break ASCII characters as part of the SQL Statement but then it just became too difficult to build a top down query using...

Thanks for the response Tim. This is a new script approach than the one i had in mind but exactly the same concept i was thinking of as follows:

1) Run...

Perfect! It worked exactly as i needed using T-SQL REPLACE function. One correction to the format:

Replace(Replace([ColumnName],CHAR(13), ' '),CHAR(10),'')

There was in fact both scenarios where Line Breaks (CHAR(10)) as well...

Thanks Jack.

I understand using the OLEDB source T-SQL statements would probably be better and more efficient. I might give them both a try and see what works. Then test...

Sounds like i need to find and replace ASCII coded character for return codes as well as line feeds?

Does this mean adding Derived Column transformations (i think that's what...

I have done a Data Conversion before but without success on ntext due to the fact that we have data greater than 8000bytes which i understand is stored in the...

I assume when i re-install RS, i can then run the SP3 update and hopefully it will be fixed and working?

My only concern is that this a Production database....

I'm not a database administrator, nor an expert with asp.net but i think our server runs a Windows 2003 64 bit O/S, however i think all application software including SQL...

Hadn't thought too much about the table columns yet but i'd like to keep the information to a minimum so the user doesn't feel like they have to give all...

Thanks to both of you. Thats exaclty the type of advice i was looking for.

Of course that is a very simple solution, however we need to keep it active for regular updates using 'sa' login.

Plus we want to restict access entirely for any...

Thanks for the point in the right direction. I can follow most of your logic so far with the permissions you mentioned. Still a little confused with the proxy account...