The error is not occuring in SQL SERVER, but in the servers Scheduled Tasks. I know it's related to SQL SERVER jobs, b/c these tasks ran fine for over a...

What user are you running the DTS as? Is it a login issue, rights?

What's the exact error?

I'd say if you could do this anywhere it would be in your transformation. You may have to customize the actual VB script to do this though. I'd check my...

Would that be the owner in the job properties?

If so I've tried several different users, all from sa, domain/username, domain/administrator. All return the same error.

I figured one of the biggest problems had to deal with real-estate. I'm not too worried about putting a large load on my server. I have 5 instances of SQL...

Thanks Guys!

The problem was missing the object owner. I did not have a fully qualified path.

Server_Name.DB_name.dbo.table_name

I was just using

Server_Name.DB_name..table_name

....

I have one more question about updating from a remote connection. I...

Just use a substring function then a convert with a style

Here's from the help:

The style Parameter

The style parameter of CONVERT provides a variety of date display formats when converting datetime...

Instead of using sp_addlinkedserver, I'm going into my Enterprise Manager,Security tab, then adding a New Linked Server through there.

The General Tab in the Properties of the new linked server is...

Ok,

So I've created a linked server, and can view all of the tables and views from the linked server, but when I reference it in a T-SQL script I get...

I'd be interested in what you find out with NOTES. It appears as if I have it working on my local installation of SQL SERVER.

I did have to create...