Viewing 15 posts - 1,621 through 1,635 (of 4,272 total)
Honestly I think that is a bad idea. Database mail is the preferred and supported mail technology moving forward. In all but the rarest cases could I recommend...
February 9, 2011 at 12:29 pm
As far as OS's that is a little trickier, but I was asking more about SQL 2008 SPx and any hotfixes.
Also keep in mind there was something a...
February 9, 2011 at 12:22 pm
I had to ask.. You wouldn't believe the number of times that it was that simple.
You might add a row counter after the destination and connect the error output...
February 9, 2011 at 12:15 pm
dzoll (2/9/2011)
sp_send_dbmail *always* returns zero as @@ERROR, but we've...
February 9, 2011 at 11:45 am
Is the Department field in the pipeline mapped to a destination column?
CEWII
February 9, 2011 at 11:28 am
The dtsx files are generally self-contained, you shouldn't generally need other files. Are the systems patched to the same level and the same version? Are the MSXML libraries...
February 9, 2011 at 11:25 am
If you can easily tell from the data a script should not be required, you can use the conditional split component, which would likely be faster.
CEWII
February 9, 2011 at 11:04 am
Unless there are a fairly large number of files (like 1000's) I don't see much of an issue just updating their status after they are processed. I am a...
February 9, 2011 at 9:06 am
The answer is yes, you mostly can..
A brief overview:
1. Pass in the connection information to a package level variable not directly to the connection.
2. Using expressions adjust the connection to...
February 8, 2011 at 2:12 pm
You could certainly deal with both of them in the same data-flow. I see only one particular issue, you could have a point where the detail exists without a...
February 8, 2011 at 2:05 pm
You might be able to do this but I think you might want to step back from the method you are proposing and tell us about the problem you are...
February 8, 2011 at 2:01 pm
I agree with Phil, please be more verbose..
If you are asking can you pull from 3 distinct sources in a data-flow the answer is yes. If that isn't the...
February 8, 2011 at 2:00 pm
I don't think you have to go through 7, I seem to remember going directly from 6.5 to 2000, this was in like 2002 so it was a while ago...
February 4, 2011 at 2:34 pm
I'm not 100% sure from your description what you are doing but here is my interpretation..
1. Pull data from SQL 2008 using OLE DB Source.
2. Using Script component as a...
February 4, 2011 at 11:54 am
I looked over the first two articles and felt that they were simplistic at best and problematic at any level.
The third article I am still digesting..
However, you can do this...
February 4, 2011 at 11:48 am
Viewing 15 posts - 1,621 through 1,635 (of 4,272 total)