Viewing 15 posts - 8,866 through 8,880 (of 9,728 total)
Just an FYI, DTS is the old stuff. SSIS is the new stuff.
If you want to do this in SSIS, I recommend reading up on the following in Books...
April 9, 2008 at 2:55 pm
The reason I ask the question is all about basic programming concepts.
If you've done programming before (non-SQL), then you probably know all about the basic concepts of structure and covering...
April 9, 2008 at 2:46 pm
Chris,
Assuming your variable is a single value, try the following:
INSERT INTO DTSSTATUS (FIELD)
(SELECT ?)
And make sure the PARAMETER NAME value of the variable in the Parameter Mapping box...
April 9, 2008 at 2:40 pm
Have you ever programmed before in any other language but SQL?
April 9, 2008 at 2:35 pm
Frank,
As a matter of fact, I just realized that an hour ago. @=) I was about to post the change (especially as I forgot to add in one of...
April 9, 2008 at 5:28 am
Look up DTUtil & DTExec in Books Online. It gives you details on how to run the package at the command prompt.
The caveat is that the user in question...
April 9, 2008 at 3:46 am
It's official. Doing the delete in the Execute SQL Task rather than trying to filter the rows ahead of time is faster by 26 minutes.
WOW.
Of course, I'm sure it...
April 8, 2008 at 12:59 pm
Okay, the Execute SQL Task might be the way to go. Since your suggestion didn't seem to like me, I tried adding a Lookup to the first pipeline (right...
April 8, 2008 at 11:12 am
Okay. Just verifying. It never hurts to check every angle just to be sure. @=)
April 8, 2008 at 9:14 am
Not necessarily. What about the difference between signed & unsigned integers? If you have columns in your flat file connection defined as unsigned, this could be a problem.
Of...
April 8, 2008 at 8:31 am
Here's a question, what is your mapping on the Flat File Connection set up as? Is it set to a datatype that doesn't allow negative values?
April 8, 2008 at 8:07 am
BETWEEN has a very nasty habit of dropping records. I don't use it at all. I prefer Greater Than / Equal and Less Than or the reverse. ...
April 8, 2008 at 7:58 am
Frank,
Hmmm. Multicast doesn't like being put after my Merge. It comes up with a totally blank screen on both sides of the divide. Apparently it can't see...
April 8, 2008 at 7:54 am
Actually, I think Matt just hit it. I don't know why I couldn't see that. It's sitting right in front of me.
DOH!
Thanks, Matt. I think that'll work.
As...
April 8, 2008 at 7:50 am
Viewing 15 posts - 8,866 through 8,880 (of 9,728 total)