Viewing 15 posts - 8,581 through 8,595 (of 9,715 total)
This may or may not work for you. NOTE carefully the ON part of each JOIN statement
Select Table1.ID, Table1.FirstName, Table1.LastName, Table2.Answer, Table4.Title, Table5.PageHTML, Table6.Location
From Table1
Left Join Table2
On Table1.ID=Table2.AgentID
and Table2.Answer...
November 11, 2008 at 11:37 am
Sounds like either an ownership chain issue or your Linked Server is set up wrong between the two.
EDIT: Sorry. To clarify, check your Linked Server to make sure it has...
November 11, 2008 at 11:30 am
I have used this before when trying to insert records in a specified order and wanting the Clustered PK Identity field to sort accordingly:
Insert into MyTable (col1, Col2, col3)
(Select Col1,...
November 11, 2008 at 11:28 am
What about the rest of the table structure?
November 11, 2008 at 11:23 am
Gaby, what exactly are you trying to do with the resulting end data?
The way you have it listed, Michael is correct about string aggregation. You could also check into the...
November 11, 2008 at 11:15 am
What's the table structure like? Is there a column that specifically distinguishes between the header record & detail records?
November 11, 2008 at 11:13 am
Stephen Fletche (10/7/2008)
The question I actually came with in the first place.. ..what's the cheapest way of doing the qualification? I don't mind blowing a couple of hundred quid...
November 11, 2008 at 11:08 am
Do you have anyone who knows T-SQL in your organization? If so, you should go to them and ask them the best way to debug a stored procedure or a...
November 7, 2008 at 7:49 am
OH, DOH!!!!
RetainNulls property is set to FALSE for all the flat file sources.
DOH!
Easy fix. @=) Happy now. @=)
November 7, 2008 at 7:35 am
It is happening after the source, which is why it's driving me crazy. I only have a source & a destination, nothing in between. So you're probably right. It sounds...
November 7, 2008 at 7:31 am
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
Viewing 15 posts - 8,581 through 8,595 (of 9,715 total)