AndyD (6/27/2008)

---

You have a couple of choices. For some people, the easiest way to import data is to do a BCP (bulk copy) into a temporary table, and then copy...

Hmmm this sounds like in might be getting closer what i'm after.. what about a convert?

However, if you...

AndyD (6/26/2008)

---

I couldn't find exactly what I was looking for (VB code for an SSIS project), but you may find that pure T-SQL will accomplish what you need. For example:

declare...

Ummm... Ok, Can I start again? :blush:

Hi guys i'm new to SSIS. I'm stuggling to convert a...

That was pretty poor form. Please accept my apologies.

Thank you for your responses. I appreciate that you took the time to reply.

Now that i've had a rant i've calmed down a bit.

Yes, in a perfect world...

Well I must say I am now completely underwhelmed with SSIS.

I couldn't get past the varchar to unicode conversion thing so I have dropped my table and recreated in with...

Well i'm still working at this...

I have a date in the format of mm-dd-yyyy and I need to put it in to a date or datetime field. After reading other...

I've been using the online turorials at msdn

http://msdn.microsoft.com/en-us/library/ms141767.aspx