Viewing 15 posts - 1 through 15 (of 91 total)
Great, I'm glad you figured it out! 🙂
March 20, 2009 at 12:45 am
My hunch is that there's still something missing here. You said you only ran these packages from BIDS, but try dtexec.exe from the command prompt. Do you still...
March 19, 2009 at 1:03 am
I'm willing that if you try to run these without BIDS, you're going to see the error. I'm not 100% certain on this, but when a child package is...
March 19, 2009 at 12:21 am
when you say you can run each package separetely and have them complete successfully, are you running them from a command prompt or are you running them from a job...
March 18, 2009 at 12:28 pm
You should probably try running SQL Profiler and capture what's being passed in by the SSIS package. That'll give you a good idea of what the system is doing.
July 14, 2006 at 1:24 pm
Instead of an array of strings, or temp tables, pass in XML variables instead.
July 14, 2006 at 1:23 pm
I agree with what you're saying. XML is a great way to pass arrays of variables into procedures, especially if the arrays need to be multidimensional in nature... parsing apart...
July 14, 2006 at 1:21 pm
The way I do it from a stored procedure is calling xp_cmdshell, then using the "dtexec" command to call the package. It works pretty well, but I'm guessing there might...
July 6, 2006 at 5:48 pm
something else to consider... with anything launched in sql server 2000, you have a limited shelf life of support left.
http://support.microsoft.com/lifecycle/?p1=2852
April of 2008 is it for mainstream support. With 2005,...
July 3, 2006 at 6:48 pm
I can't think of any real productivity gains. I happen to like Management Studio better than query analyzer, but the basic technology's still the same. I'd argue that you're more...
July 3, 2006 at 6:41 pm
I run the risk of being wrong here since I don't know the internals of your package, but it sounds like you've set up a package to run all of...
June 26, 2006 at 6:09 pm
Yeah, I like the fact that this product sits pretty seemlessly on top of Management Studio. It makes me wonder if microsoft is ever going to get their own version...
May 26, 2006 at 11:01 am
As a good friend once said "if it isn't painful, it's not worth it."
May 18, 2006 at 11:22 am
if they're on the same server, that's easy. You just need to use the following naming convention:
select * from
database1.dbo.table1
select * from
database2.dbo.table1
You can even join the values together...
select *
from...
May 17, 2006 at 11:40 am
Database mirroring should be enabled & supported by SP1. The article's old.
May 17, 2006 at 11:30 am
Viewing 15 posts - 1 through 15 (of 91 total)