I changed the account over to my domain account and everything worked fine. We tried creating a new domain service account (only used for this stuff) but it got...

GilaMonster (4/17/2009)

---

Wrong place.

I'm talking about the windows accounts that the two services run as. First you need to find out what they are, check the services app from Administrative...

GilaMonster (4/17/2009)

---

Permissions?

Running through BI dev studio it'll be running under your credentials. Running as a SQL job it will be running either as the SQL Server service account or...

That's the weird part. I have an ODBC sql tool that I can run queries in, and the query is running fine for that odbc connection. And I...

The issue is in the datareader, so going out to the progress db is an issue. When using For Loops, is there a certain number of connections I can...

I am having an issue that you might be able to help me with - I've got it all set, but I would like to have it so that if...

I think I figured it out.

I have a table on my sql machine that has a table with two columns, one for the connection string, one for a building ID....

Sorry about that. I felt stopped by not being able to set up the connection right.

Thanks for your help.

[update 11am]

I think I understand now. I need to set...

CozyRoc (3/16/2009)

---

You can put your connection information anywhere you want. The idea is that it should be a list you can iterate over. I would advise a SQL table. If...

CozyRoc (3/16/2009)

You need only one variable and you use this variable in the expression. You have to have a list with databases and each database iteration will be stored in...

CozyRoc (1/20/2009)

---

Yes, you can. You have to store your connection string in package variable....

UPDATE - yeah, they both have XP svc pack 2 and SQL Service pack 2.

hi,

thought that might be an issue, but they're all 32bit, thankfully. I am going to...

By the way, I don't have to run it as a SQL Agent job if there is another way of doing it. I just want to run this package...

So I need to set it up to run with the Agent's credentials in BIDs? I'm not sure I understand how to do that.

Thanks man, I'll look into that further, but I thought replication was a 2008 technology. I'm a developer who's being forced to be the dba as well 🙂