When I have used temp tables in my SSIS packages, I use a local (one #) temp table. I believe that as long as you set the RetainSameConnection and...

You would use the Windows password for the domain account.

I am not sure about the setting up the Principals tab. In my case, the proxy account I have used...

You will need to set up a SQL Agent Proxy account on the local server using the domain user they set up on the remote server. From SSMS you...

In MS Access 2003 there is Tools > Analyze > Documenter which will display the properties of the MS Access objects. You can select the objects and properties you...

Unfortunately it sounds like nothing short of a server restart is going to clear this headache for you. This issue you have discovered is making a good case to...

David McKinney (6/4/2010)

---

James Stover (6/4/2010)

---

James Stover McDBA - is that like an Irish DBA?

Geek humor - gotta love it! I've had my chuckle for the day... now back to...

It sounds like the task scheduler is caching your environment variables. I Googled that and came up with this: http://msdn.microsoft.com/en-us/library/aa380715(VS.85).aspx

That's probably whats going on. I would assume that...

I believe the FileSystemTaskSource property would be the name of the source not the value of the source. My recommendation is to use your expression to set the value...

I have never had occasion yet to connect to a database from within a Script Task, but I decided to spend a little time to see how it's done. ...

In a broader sense, it uses VB.NET, so becoming familiar with the .NET...

We run dozens of SSIS jobs daily. I use the [SSIS Configurations] table to store all of our package configs. This works well for us. Everything is...

It sounds like you need to keep your connection string in a Package Configuration and not inside the package itself. Package configurations can be stored either as files or...

Are you running this interactively from the BIDS designer, or have you deployed to the server and running it from there? If it's the latter, how have you set...

Ah... a special unicode character. Well that does make it a bit messy then. We also have an iSeries system, but I have never had to deal with...

I never knew there was a difference. I don't see anything like that in the standard ascii character table. If you look at it in a hex editor,...