I should have looked on this web site harder. Found the solution to my (first) issue: the variable that the Execute SQL task goes into needs to be an object...

For the given test data (thanks for that!), what should the output look like?

Also, I can't get your cursor/cte to run.

Edit: got the test code to run, I see what...

DBA (5/5/2009)

---

when creating a table we made a mistake it was supposed to be an integer column and is supposed to store by default a distributer ID using a function....

If it makes any difference, I think you have a decent SQL skill level... 😉

Loner (5/5/2009)

---

This is the most ironic thing. Some of the best developers and DBAs did not have a computer science degree. On the other hand some the of...

Datetime data types are internally a float. The whole number portion represents the days, while the decimal portion represents the time.

ie:

select CONVERT(float, CONVERT(datetime, '99991231 23:59:59.997')), CONVERT(float, GetDate())

If you change the...

Well, this might give you a little more information than what you asked for. Not only does it include the owner name, but also the table name, as well as...

I don't have a degree. I have been to college, but just haven't finished.

I "fell" into computer because of college in 1978. I was studying for Electronic Engineering, and...

Now that is an awesome analogy. Your dad is...

Hey Roy... very good (okay, GREAT) article.

I thing to emphasize... as long as you need that backup, you need to keep the security certificates. Think SOX. You may need that...

ifila (5/4/2009)

---

(1) I have a program written in VB6 that parses the text files, then i load after the parse process is complete. The parsing takes about

1 hour per...

I think at this point that we're going to need to see the data being modified. It would also help to see the table structure, and the command(s) being issues...

Please don't cross-post. Check the other post you did. http://www.sqlservercentral.com/Forums/Topic709311-391-1.aspx

Please don't cross-post.

Check the other post you did http://www.sqlservercentral.com/Forums/Topic709310-145-1.aspx

Hey Jeff... If you need to test anything, I've got 2005 & 2008 Dev Editions on my laptop.