Thanks for the information!

I appreciate those who took time to look at this issue with me. In the meantime, I found a solution that was 98% of the exact code I needed.

It...

Those sound like very good reasons ... thanks everyone! 😀

Thanks! 🙂

Good article! Just what I needed ... Thanx! 🙂

Thanks for your input, Dan.

I don't think this is the case. All of this happened while logged on as the same user, same server, and same PC. When I...

[You only need to install it on you own development machine. If it is not your own computer, than you'll need to fumble with the deployment wizard 🙂

Or you can...

Koen Verbeeck (3/4/2011)

---

Instead of fumbling with the deployment wizard and manifesto, you can install BIDS Helper (it is free). It allows you to deploy packages and projects with a simple...

Someone suggested that I forget the Derived Column and Data Conversion transforms for directly casting in the SELECT statement. I did that and it looks like this:

SELECT LEFT(CAST(HTML_Original...

My image was hard to read. I am reproducing the Help file steps below. I got to Step 3 and got stuck.

To create a package deployment utility

1) In Business...

I am trying to use the SSIS Derived Column transformation to convert FROM NTEXT.

Here is an image of what I am seeing:

Basically, I am trying to go from SS Ntext...

Thanks! I will give it a try tomorrow when I get to work.

Thanks, Lowell! I will study your work tonight.

Good article ...

---

A topic I wish had been addressed is how to handle nulls in datetime fields. I think that you do the following. Let me know if there...

Its not clear to me what part of this problem you are having difficulty with. Is it the handling of parameters in DTS? Is it exporting to Access.

If its...