Viewing 15 posts - 8,596 through 8,610 (of 9,720 total)
Edit the task. Look at the left side of it when it opens up. You'll have four "tabs". General, Paramters, Results and Expressions. Check each one. In General, the Results...
November 7, 2008 at 7:26 am
Here's your main info:
"Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly"
First check the "UPDATE AND APPEND DATA"...
November 7, 2008 at 6:51 am
That's what it looks like. The .bat file appears to be running a package, so trace back to the package and see what you can find.
November 7, 2008 at 6:34 am
So you're running this from the server? Not from BIDS?
If so, then create a job with an Operating System Command line and insert the Command Line from the "Run Package"...
November 7, 2008 at 6:27 am
What is the error you get when you make these changes?
November 7, 2008 at 6:22 am
We need a better description. What object are you talking about? A connection string? A table name? A column? A stored Proc?
Please clarify and we'll be able to help you...
November 7, 2008 at 5:20 am
You need to look at the rest of the output. The line you quoted comes at the very end of the output.
When I'm running in Debug mode via BIDS, I...
November 7, 2008 at 5:19 am
MAPI usually has to do with Email. At a guess, I'd say your .bat file is trying to use the old fashioned (and depreciated) SQL Mail from previous versions of...
November 7, 2008 at 5:15 am
Want a quick and dirty way of getting an SSIS package for your Access db to SQL Server?
Go into your "Dev" environment on SSMS. Rightclick a database and choose All...
November 7, 2008 at 5:13 am
YOu can use a "Select Into" to maintain your identity in the new table, but it won't retain PK / Relationship stuff. Suresh is correct. The best way to handle...
October 30, 2008 at 3:08 am
Submitted & waiting for approval. @=)
Though if I see you again at SQL Saturday, I'll tell you in person. @=)
October 25, 2008 at 3:24 am
Jeff may disagree with me on this, but here's my take on interviews.
Know your stuff, but if you can't answer the question, be honest about it. Tell the interviewer that...
October 24, 2008 at 3:48 am
Did you actually install SQL on the new box as part of a cluster or a standalone server? This is one of the options upon install. If you didn't...
October 21, 2008 at 8:14 am
Viewing 15 posts - 8,596 through 8,610 (of 9,720 total)