Viewing 15 posts - 976 through 990 (of 3,232 total)
It would be much easier to help if you'd provide the table schema and sample data in a readily-consumable form.
Here's an exmple of how to post sample data...
October 14, 2009 at 4:25 pm
Do all of the files have the same format? If so, you'll only need one file connection. You can use a For Each loop container to loop through...
October 14, 2009 at 4:12 pm
An alternate workaround could have been to replace the table in the DSV with a named query and used the CAST funtion inside the query. I chose to change...
October 2, 2009 at 3:13 pm
OK, so I've found that this is a bug. The bug was reported quite a while back and there appears to not yet be a fix for it.
When you...
October 2, 2009 at 1:45 pm
Really, nobody has seen this before or has any insights into what I'm seeing?
C'mon folks!!
October 2, 2009 at 12:10 pm
I agree. Getting the data from the OLE DB source component here may be better. Typically, the source data is comming from a seperate system then where you...
September 25, 2009 at 11:09 am
That's where I was going to go with this too Jeff, the ANSI JOIN syntax. I wanted to see the table structure though because I noticed that the join...
September 23, 2009 at 9:49 am
You'll need to be careful with #1. SSIS is very metadata dependant and a stored procedure that returns a different result set based on parameter values can cause problems....
September 22, 2009 at 1:44 pm
If the SP logic is not something that you can dulicate inside a data flow, I would suggest backup up and using the For Each Loop container with an Execute...
September 22, 2009 at 1:38 pm
Ah, I didn't see that. OK, I just wanted to see if that was being accounted for. It seemed like we were on different pages there for a...
September 22, 2009 at 12:54 pm
Elliott W (9/22/2009)
September 22, 2009 at 12:18 pm
Can you post your table DDL for customer and address and include the index definitions?
September 22, 2009 at 12:14 pm
Even w/ multiple data flows, the challenge is still to have each data flow work on a distinct subset of the data. If you have 100 rows that need...
September 22, 2009 at 10:02 am
Here's an example of getting the plan into the forum thread.......
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 22, 2009 at 9:03 am
Elliott W (9/22/2009)
John Rowan (9/21/2009)
September 22, 2009 at 8:59 am
Viewing 15 posts - 976 through 990 (of 3,232 total)