Andy Leonard (6/23/2009)

---

I've done battle with similar stuff. I can't put my finger on a link right now, but the way I'd approach this is to use an OLE DB...

It's on x64 but I'm calling it with DTExec to get around that:

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "D:\SSISShare\package.dtsx" /CHECKPOINTING OFF /REPORTING V

Here's something else to add to the argument:

Configure SQL Server memory for best practices.

Sounds easy, right? Go into SQL Server Management Studio, right-click on the server name and click Properties,...

Steve Jones - Editor (6/11/2009)

---

Strange, it seems as though it has to be security/permissions then for the main package. Is there a proxy account you can set just for a...

It's actually not failing on any step when run straight out of BIDS on that development server.

We are running it though the agent as file system. Does the MsDtsServer issue...

I have been toying with using this sort of thing in our environment. One problem I ran into was the using the stored procs to update the table and figuring...

Really good article. I'm going to adapt my current configuration table to use a trigger similar to yours since I hadn't thought of that.

I finally figured it out. Data Conversion and 2 Derived Columns later and I'm good.

It's an OLE DB Source on a table. On the Data Flow Path Editor it's DT_STR.

great find. That did it.

running the query locally on the server.

tried with -q, -v, and without anything.

If I got some type of error that might help me know where to look but I've got...

ok, so lets assume we are dealing with domain\login as the account in question. It runs both the engine and agent.

Under the OS, you have a group called Administrators. Within...

I normally do this sort of thing without a cursor while still using a loop but I don't have time to play with it right now.

Since you mentioned being...

I think you should submit an article(or series) as well.

If you do a SELECT * FROM information_schema.tables you'll see that there's a column there called TABLE_SCHEMA. That's where you'll find your dbo. I'm assuming you are wanting to handle...