Add "USE [?];" at the begginning of the string. That's what sp_MSForEachDB uses to plug in the database name.

That's pretty much how I learned SSIS. Build something that can just barely do a "hello world" version of what I'm trying to accomplish, then move on to adding...

I'm in the same boat as a few others. Web development and design would actually be a distraction from what I get paid to be good at.

The best thing I...

The VPN client my company uses allows me to RDP to the server, but blocks all other network connections I would establish from the local desktop. Can't locally browse...

The function you need is "NullIf".

select NullIf(@Field24, '')

If the first value equals the second value, it returns a null.

You'll have to convert varchar(max) to text to get it into SQL 2000. A data conversion point in you data flow should be able to do that for you.

I'm not sure what you mean by "let go of".

kwoznica (6/7/2011)

---

GSquared (6/7/2011)

---

SSIS has a built-in FTP task operator. It won't work with SFTP ("Secure" FTP), but if it's vanilla FTP, it should be able to do what you...

It sounds like you did really good work. That's promising. If you want more details on how good, etc., you'll want to talk to people who manage projects...

markanderson (6/7/2011)

---

Very little sleep and data type issues are making me cranky... sorry as well... my bad.

I think I am going to take your point on the fact that mathmatically...

patla4u (6/7/2011)

---

You are saying that sql server generate a query randomly

like

ACCT_ID ACCT_NO ACCT_NAME ACCT_ROW

1 11 ABC 100.......................................(yesterday)

1 11 ABC 101.......................................(today)

2 12 XYZ 102.......................................(yesterday)

2 12 XYZ 103.......................................(today)

or

ACCT_ID ACCT_NO ACCT_NAME...

Start with restoring model. See if that solves it for you.

If the service won't start because it can't create tempdb, you may need to repair the installation. There...

Jason L (6/7/2011)

---

remember that the ... (repeating) means repeat for infinity, so it impossible to find the value between 0.999... and 1. Unless we use another notation, does 0.000...1 +...

Better glasses needed maybe?

Buy a better calculator...