Viewing 15 posts - 106 through 120 (of 131 total)
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...
April 18, 2009 at 7:10 am
GilaMonster (4/17/2009)
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...
April 17, 2009 at 2:25 pm
GilaMonster (4/17/2009)
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...
April 17, 2009 at 12:24 pm
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...
March 20, 2009 at 2:16 pm
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...
March 20, 2009 at 1:44 pm
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...
March 20, 2009 at 1:14 pm
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....
March 17, 2009 at 6:14 pm
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...
March 17, 2009 at 8:02 am
CozyRoc (3/16/2009)
March 16, 2009 at 3:50 pm
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...
March 16, 2009 at 2:05 pm
CozyRoc (1/20/2009)
Wasn't sure if you could pass an odbc connection string as a param to a for loop.
Yes, you can. You have to store your connection string in package variable....
March 16, 2009 at 12:26 pm
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...
February 9, 2009 at 3:02 pm
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...
January 30, 2009 at 12:32 pm
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.
January 30, 2009 at 12:08 pm
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 🙂
January 20, 2009 at 9:42 am
Viewing 15 posts - 106 through 120 (of 131 total)