Viewing 15 posts - 2,446 through 2,460 (of 3,232 total)
You cannot prompt for user input in stored procedures either. The only way I see to prompt the user for input is to do as you plan and create a...
January 25, 2007 at 1:32 pm
I don't consider myself a DTS guru, but I have worked with it a great deal and have created some pretty complicated packages. I have never seen or heard of a...
January 25, 2007 at 11:18 am
I'm a bit confused. So you did or did not get my example to work? Also, isn't the point of this so that you can pass in your global variable...
January 25, 2007 at 9:34 am
The KB article that you posted earlier states that the fix for that problem is in SP2. If you client has not applied SP2 as of yet, you should strongly...
January 22, 2007 at 10:36 am
It looks like you've got some redundant references to your package in your DTSRUN command string. I can't say if this is your problem or not, but consider this example:
Set...
January 22, 2007 at 10:01 am
It's hard to give you more guidence on this without knowing more about the process. Can you walk us through the logic of how you get a file, how you...
January 19, 2007 at 1:51 pm
Yep, that works too. Russel's solution will be simpler to write. If all you need to do is send the SP results to a file and that file name can...
January 19, 2007 at 1:41 pm
Carl's solution will work quite nicely if you can swing it. Instead of moving all of your data, you change the view to point to the current data. I know...
January 19, 2007 at 1:16 pm
I think the best way to grasp what this is doing would be to set up some mock data and break the query down into parts to see what it...
January 19, 2007 at 1:10 pm
DTS does have the ability to read in a text file. If the file name is dynamic, you'll just have to get creative in designing your DTS tasks. You could either read...
January 18, 2007 at 5:26 pm
Yes, Sergiy is correct in saying that a SP will not stop the ability to insert more than 50 rows. I was assuming that the SP would be used for...
January 18, 2007 at 5:11 pm
I guess you could say they are Constants in the way that the article uses them as you would need to change the job to change the values. I meant...
January 18, 2007 at 5:09 pm
You've got a couple of options here. Either create a stored procedure to 1. check the current row count; 2. delete oldest row if needed; 3. insert new row, or...
January 18, 2007 at 4:48 pm
Funny you mention that. When I was typing my response, I initially started with 'Outside of removing your hard disks and shipping them ....' but then I figured...nah. I guess...
January 18, 2007 at 4:42 pm
Viewing 15 posts - 2,446 through 2,460 (of 3,232 total)