You've been given some great guidance from...

Can you rephrase your post please? It looks like some info did not make it into the post and the wording is not clear as to what you're experiencing or...

Depends on what kind of position youre looking for. If youre getting calls for Access Programmer positions (eg Forms and Reports dev) and you are not interested in that then...

As an aside, do you control the design of these tables? Typically it is not a good practice to store delimited strings in your database. What kind of data is...

What have you tried so far? You could lookup the functions CHARINDEX and SUBSTRING in Books Online to get started towards a solution.

This thread comes up on Bing when searching for a way to capture the contents of a cell with a date in it and nowhere else I could find specifically...

I could not get this to work using a mapping to a scalar variable in the Execute SQL Task. It will work by pulling a Full Resultset and...

MMartin1 (1/20/2016)

---

Just have to ask, you mentioned you tried all the data types in SSIS. I assume this includes the "double" type as well? I am surprised it would fail...

Thanks. I'll give it a spin later tonight.

Actually, if memory serves, there are algorithms for calculating all...

Ed Wagner (1/20/2016)

---

Orlando Colamatteo (1/20/2016)

---

ScottPletcher (1/20/2016)

---

Orlando Colamatteo (1/19/2016)

---

ScottPletcher (1/19/2016)

---

Of course that code doesn't specify the date key, so it will do a full table scan. Again, vastly too much overhead...

Yes, but you know the current state and desired end state.

Check this out:

USE tempdb;

GO

IF...

ScottPletcher (1/20/2016)

---

Orlando Colamatteo (1/19/2016)

---

ScottPletcher (1/19/2016)

---

Of course that code doesn't specify the date key, so it will do a full table scan. Again, vastly too much overhead when two very simple...

PSB (1/19/2016)

---

We are doing a BCP because of the amount of rows to be fetched from Server 1 to Server 2 . The time shrinks to 2-3 minutes from 30...

duplicate post

http://www.sqlservercentral.com/Forums/Topic1753899-364-1.aspx#bm1754000