Viewing 15 posts - 946 through 960 (of 3,232 total)
What about your indexing information for all of the tables involved?
October 28, 2009 at 1:31 pm
steveb. (10/26/2009)
You will need the correct indexes to speed up the query.Can you post the table and index structure as well as your query and execution plan?
We're still waiting...
October 28, 2009 at 12:32 pm
I would not drop the procedure or 'blank' it out by modifying it. I would stop the process running the procedure. What initiates the procedure call?
October 27, 2009 at 1:47 pm
You could define a variable for each of your validation types and use the RowCount transformation to get the count of the rows that go down each of the validation...
October 27, 2009 at 12:20 pm
I would imagine that much of your problem lies with the UNION ALL. You are forcing the query to access your large table multiple times, 4 in this case,...
October 27, 2009 at 12:06 pm
SSIS is very data type dependant. When importing from flat files, you always want to ensure that the source data types match your destination data types, particularly for string...
October 23, 2009 at 9:27 am
You can use the Data Flow complonents inside of SSIS to clean up your data or ignore invalid data.
October 17, 2009 at 11:54 pm
You attempted to use the Simple Case Function where you needed to use the Searched Case Function.
If you look at the BOL syntax explanation for each Case type, you'll see...
October 17, 2009 at 10:51 pm
It may seem counter-intuative, but the old DTS worked this way too. A failed task fails the package which means that no further tasks will be ran. As...
October 17, 2009 at 7:10 pm
What type of task is failing? I assume then that the task fails and fails the package? Have you tried putting the e-mail notifiction into the OnError event...
October 16, 2009 at 2:36 pm
I guess the real question would be......why? Why would you ever need to do this?
October 16, 2009 at 2:34 pm
This sounds to me like you need to do this one time for all of the data and then develop a process to keep the 'reporting' table up to date....
October 16, 2009 at 2:17 pm
By the way, I was not trying to be short. Format files are what you want to use. Read up on them and give using them a stab....
October 15, 2009 at 4:32 pm
What connection provider are you using?
October 15, 2009 at 3:34 pm
Viewing 15 posts - 946 through 960 (of 3,232 total)