Viewing 15 posts - 1,501 through 1,515 (of 7,636 total)
1) Include a SQL Script Task in the control-flow, probably before your data-flow task runs.
2) Yes, but it is a Kludge and a potential security issue. SSIS, is not...
October 1, 2009 at 8:09 am
And before someone says it, yes I know that the XSD hierarchical definitions can be interpreted as Relations, but they are not the same and there are a lot of...
September 30, 2009 at 8:23 pm
I do not have the answer that you are looking for, however there are a few things that you should be aware of:
1) Replication does not require disk-mapping to work....
September 30, 2009 at 8:16 pm
Though in truth, my actual preference is to import to staging tables where I can take care of this kind of thing myself before putting it into the production tables.
September 30, 2009 at 7:52 pm
krypto69 (9/30/2009)
Thanks for answering..I think the issue is I'm trying to insert 'empty' into a datetime column...
Should I have the vender change the empty's to 'NULL'?
No, you should get them...
September 30, 2009 at 7:49 pm
It's possible. You should open the file yourself and see exactly what is there.
September 30, 2009 at 2:33 pm
info-1153976 (9/30/2009)
CPU 0%
BCP is in task list with 0% CPU and nearly 4 MB memory consumption
there is also a cmd.exe...
September 30, 2009 at 2:28 pm
Jack Corbett (9/30/2009)
I don't think that is a glitch. I don't think the forum has ever really shown the description. I don't think the OP knows what the...
September 30, 2009 at 2:02 pm
What's really odd is that according to Goggle, this problem (VB comments) was fixed back in January.
September 30, 2009 at 1:23 pm
So [ code="vb" ] has been removed then? Wow, that's a bummer.
I have tried to replace it with [ code="other" ], unfortunately, "other" seems to mean C/C++/C#/Java or anything...
September 30, 2009 at 1:12 pm
Right, the real failing isn't the language syntax, so much as it is what the optimizer does with it. We all know how to write a Running Total using...
September 30, 2009 at 12:58 pm
sid18in (9/28/2009)
I have asp.net website, so I am not sure you know this or not. If I separate my database do i just have to change the connection string for...
September 28, 2009 at 5:16 pm
Garadin (9/28/2009)
September 28, 2009 at 4:14 pm
Oops, someone beat me to it. Still, I highly recommend Gail's article which explains what's really going on very well.
September 28, 2009 at 3:51 pm
This is most likely a problem know as "Parameter Sniffing". You can read this[/url] excellent article by Gail Shaw (Gilamonster) who explains it much better than I.
Long story short:...
September 28, 2009 at 3:50 pm
Viewing 15 posts - 1,501 through 1,515 (of 7,636 total)