I dropped a Script Task and wrote C# code to find and replace. Problem solved. Thank you for your input.

I need to read through .txt files like the sample daily and remove the

(space and E) so that the SSIS execute SQL Task will be able to execute the...

I need to read through this .txt file containing the DML code I placed in the post row by row and where ever I encounter (space and E) I want...

I have written a utility that our users need to be able to run form a Central database that is accessible by all users. In this Database, resides...

Both of your suggestions worked. thanks a lot. I'm getting the hang of this T-SQL thing.... little by little...

That works. Thank you.

I found the solution below. I do appreciate you taking the timne to read my post.

Here is the solution if anyone else has a similar project.

Use DHL_KEMP_Load

Declare...

I had this error way back in the day. If you are using a new version of Excel - 2010 and you SQL Server Version is 2008 the Jet...

I had this error way back in the day. If you are using a new version of Excel - 2010 and you SQL Cerver Version is 2008 the Jet...

I will check out the link Lowell provided annd also contact SalesForce support. Thank you all for your assistance and posting guidance...

I understand. It is out of the province of SQL Server SSIS. I see no transforms available in SSIS to accomplish this feat. I will turn this...

This is my first time having to rerender the binary data that is stored in the table field, so I am not sure what to use on the front end...

I'm new here and made an honest mistake in posting to more than one forum. I thought this was supposed to be done because I don't know if my...

I cvan appreciate your saying that SQL Servers function is to store, but SQL Server has a lot of other capabilities with the CLR...

I do not know much about .Net....

Did not know that. I'm new here as you ought to be able to see. If you have nothing further to add to my inquiry I will bid...