Viewing 15 posts - 1,216 through 1,230 (of 3,232 total)
How are you handling when more than one column's value is updated?
August 5, 2009 at 4:17 pm
Yep, that's clear. I understand what your stored procedure is trying to do. What I'm unclear on is what you are wanting help with. What is your...
August 5, 2009 at 4:15 pm
No problem, glad to help.
August 5, 2009 at 4:13 pm
I'm not clear on what you want to do. Can you provide an example of what you want your SP to return given a specific input?
August 5, 2009 at 3:44 pm
OK, you're close, but now quite there. I should have expanded my explanation a bit in my previous post. Here's what I did to get my example to...
August 5, 2009 at 3:32 pm
For what it's worth, I third the motion to see this in an article. Have you done any time/performance comparisons on this method versus the SCD transformation?
August 5, 2009 at 3:15 pm
Where do you get this error? In the OLE DB Source component?
August 5, 2009 at 2:55 pm
I would create a package level (or scope it to the data flow) variable of type int and set to zero. The code in the Script Transformation will use...
August 5, 2009 at 2:52 pm
Have you ever been able to connect to this SQL Instance? Are you the SQL administrator?
August 5, 2009 at 2:44 pm
You could pull this off with SQL Server profiler along with some well written queries to pull the server level performance metrics. As far as a third party tool,...
August 5, 2009 at 2:22 pm
So is this happening in a data flow? Are you using an OLE DB Source? I had a similar problem pulling data from Teradata into SQL Server. ...
August 5, 2009 at 2:19 pm
This sounds an aweful lot like a homework question. Why don't you post the table DDL and the SQL code that you've written so far so we can help...
August 5, 2009 at 2:11 pm
Add a Derived Column Transformation to your dataflow to hold the Identity value, default it to zero. Add a Script Transformation and increment the ID value in the script.
Just...
August 5, 2009 at 2:09 pm
rsteckly (8/5/2009)
.......I'd like a tool that monitors the database server(s) and notifies me when issues arise. Ideally, this tool would allow me to export the data.
I'd like to be...
August 5, 2009 at 1:56 pm
Viewing 15 posts - 1,216 through 1,230 (of 3,232 total)