Viewing 15 posts - 991 through 1,005 (of 3,232 total)
It looks like your execution plans got hosed when you posted them. They're riddled with garbage from the formatting. Was that the XML plan? You'll need to...
September 22, 2009 at 8:37 am
It may be possible, but the only way I see it working would be for you to dynamically create data flow tasks based on your # of desigred 'threads'....
September 21, 2009 at 4:36 pm
That would depend on what you would have done inside your stored procedure. Can you tell me what your SP logic would have done?
September 21, 2009 at 2:22 pm
This should be done inside a data flow, not using a stored procedure and for each loop.
September 21, 2009 at 1:55 pm
Yes, you can iterate through a result set and call a stored procedure, but I'd be real carefull about what you use this for. You're creating a RBAR process!
What...
September 21, 2009 at 1:27 pm
Agreed. All RI constraints need to be built out on the base tables.
Also, if they are using the Linq to SQL portion where Linq is building out...
September 17, 2009 at 4:51 pm
It also gives the database users an idea of which candidate key may have the clustered index on it. I know that Primery Keys do not have to be...
September 10, 2009 at 4:31 pm
The OP has not responded for quite some time now.
SQL Learner? Are you still working on this? We'd appreciate some feedback as to how you've resolved the problem....
September 10, 2009 at 10:26 am
I think there's some quarkiness (new word?) with how the look up task works w/ custom queries. Try this:
1. Add your begin/end dates columns into the pipeline via Derived...
September 9, 2009 at 10:02 am
I have not seen this before, but it probably has to do with your destination adapters. If you want to create an Excel workbook, you need to use the...
September 8, 2009 at 4:27 pm
Elliot has some real valid questions here. It's one thing to just build something that works and another to build out a production process that is best for system...
September 8, 2009 at 12:24 pm
Yes, it only lets you map to columns. Elliot has the solution. Use the Derived Column task to get the values into your pipeline. There, you can...
September 8, 2009 at 12:00 pm
EXISTS evaluates to a boolean value, so true/false, based off of the query inside the EXISTS clause. The way your query is written, you'll get all rows from...
September 8, 2009 at 11:58 am
Have you tried using a derived column with the correct target data type as opposed to casting it in the SQL statement?
September 8, 2009 at 10:33 am
Viewing 15 posts - 991 through 1,005 (of 3,232 total)