Search results for query: *

I'm trying to set up a SQL Server Agent account and I just hit a wall. I was following these instructions. http://msdn.microsoft.com/en-us/library/ms187901.aspx and http://msdn.microsoft.com/en-us/library/ms190703.aspx When I was creating the SQL Sever Agent Proxy it started to error out...

I have a production IWR 7.1 server that stopped running IWR reports yesturday. This happened once before and the tech support person, whom I am still waiting on to return my call, said that if impserver.exe is not running in task manager then the IWR reports won't run. Welp, it isn't running...

I'm having trouble getting a stored procedure to work in Impromptu. I've set up 3 parameters in the stored proc, and I created three parameters to pass to it. I have called it two different ways with neither working. I've included the error message with each. Can someone show me what I am...

I see your point. I was moderately happy; but was thinking a raise was potentially in the plans. I think I simply want to know what's a prevailing or fair rate distribution. Is it a fair percentage? Is it gouging? What do people think of this kind of spread?

I'm a Business Intelligence Analyst using SSRS, SSAS and SSIS, SQL Server and Oracle databases. I am working for a contracting company and the other day, my boss at the client site let it be known what my billing rate is. He left the bill on his desk as I was talking to him about something...

I am downloading an XML file from a trusted source and would like to allow for DTD inside an XML file that is being downloaded through SSIS. Can anyone tell me how can I set the ProhibitDTD in the XMLReaderSettings to false for SSIS processing? I can't find anyone who can tell me how to...

I have a database instance that is nothing but a linked server place. In it, I can do something like this... select acctkey,acctno from imsv7.account@HVDEV.world or select acctkey,acctno from imsv7.account@HVPRD.world Each time I substitute the Database environment I want to query out of. The...

I have a need to connect to a database that serves as a redirector of sorts to different database environments. In this linked database you can run the following command and get data from each of the databases that are set up as a linked server. select acctkey,acctno from...

I see your point, but I'm its already done. Any chance you see the problem? Or is your screen just small? I have can see 90% of it.

I have a stored procedure that is acting kinda funky. I didn't write it, and so that could be contributing to my not understanding it, but I think something is fouled up and I'd like to ask for your review because data I would have thought my delete statement removed is not being removed...

Would you think that by taking Microsoft classes 2794, 2795, 2796 and 2797 from a vendor would prepare for BOTH 70-445 and 70-446? I found a vendor who claims this. The curious thing is that Appdev claims they can teach you through 70-445 by teaching SSAS, SSIS, SSRS, however feels that they...

Did you find any practice exams? I'm about to purchase AppDev's training for the 445 and I'm nervous because I can't find any company that has any practice exams. Thanks, Keith

Hey everyone, I have a story I'd like to share with the aim of getting some career/certification advice. I'd appreciate as much input as any one is willing to give. I got my CIS degree in 1995 from a State University Business school. I worked as a COBOL programmer for 3 years (1 company)...

Hey everyone, I have a story I'd like to share with the aim of getting some career/certification advice. I'd appreciate as much input as any one is willing to give. I got my CIS degree in 1995 from a State University Business school. I worked as a COBOL programmer for 3 years (1 company)...

If you are asking me to confirm, rather than saying I should consider it confirmed, the problem with my confirming is that I've switched roles and don't have access to that package. I can put in the FAQ that it seems that step is unnecessary, but that I do not have confirmation. How about I...

I'm thrilled to have my blunders help someone else! I never actually posted the FAQ because I wanted feedback. I don't have time to check #20. If you are certain that step isn't needed I'll post it. Do you mind that I confirm that?

I don't know where I would set it in a config file. Also, it may not be hardcoded per se since you point to it in the destination file when you create it.

Oops, you'll have to cast the concatenation of 0:0 + MyTimeCol into a varchar.

Throw this into a case statement and do a length check on the field. When its 1, concatenate 0:0 + x I wrote this in Psuedocode cause I gotta run: case MyTimeCol when length <=1 value = 0:0 + MyTimeCol else value = left(cast(MyTimeCol as varchar),len(cast(MyTimeCol as...

I have an SSIS package that I created that looks like the following: Execute SQL Task [Determines the file name] Data Flow Task Source - Query [Grabs the data] Destination [Saves data to file on network drive] Send Mail Task [Tells user to get file from network] When...