Viewing 15 posts - 9,286 through 9,300 (of 11,676 total)
Whoops, apparently it is backwards-day today 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 29, 2011 at 12:14 am
Jim Murphy (6/28/2011)
Awesome. Congrats! For the award, not the traffic jam.
Thanks. (also thanks to Jeff and the rest).
Two accidents yesterday evening at very strategic places, which resulted in an...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 29, 2011 at 12:07 am
hallhome (6/28/2011)
I just figured it out. Thanks !
Great, glad you found the solution without me typing anything 😀 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:53 pm
Grant Fritchey (6/28/2011)
First person I know to get one. Well done!
Thanks!
I started at a new client today, and when I first logged into my new development station, I immediately noticed...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:44 pm
In the flat file connection manager, type " in the text qualifier text box. (in the general pane at the format section)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:40 pm
You need to copy the event handler as well. Each task in an SSIS has its own event handlers, so you'll need to create a new one for the new...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:31 pm
Difficult question today...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:29 pm
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congratulations.
I did my very first technical session last week (on...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:01 pm
First take a backup of the .dtsx file.
Then remove the entire DTS:Executable node in the XML file.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 27, 2011 at 5:26 am
Great question, but a bit hard for a Monday morning 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2011 at 11:57 pm
The problem is that the events from the task propagate from the task itself to the package.
This has the consequence that the event handlers are fired more than once.
For example:
package...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2011 at 11:45 pm
So if I understand it correctly, an event handler just checks a table, but for some reason child packages are not executed?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2011 at 5:39 am
The logging config table is what exactly?
A config table that contains a package configuration that sets the connectionstring for the log provider?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 6:31 am
Both formats will work.
1. Text with spaces: the space is not listed in the dropdown box as a delimiter, but you can type in that dropdown. Just type in a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:53 am
Can you explain in more detail why you have an Oninformation event handler with a script task that goes looking into a log table?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:39 am
Viewing 15 posts - 9,286 through 9,300 (of 11,676 total)