Viewing 15 posts - 11,236 through 11,250 (of 13,861 total)
Lisee (7/14/2011)
That's okay - I'm sure I'll have a ton of SSIS questions once I figure out how it fits into the scheme of things! 🙂
Haha, that will give...
July 14, 2011 at 6:00 am
b.narasimhakumar (7/14/2011)
when we compare all the fields of result set it is unique
from there...
July 14, 2011 at 4:25 am
Change your selection query to eradicate the duplicates at source.
July 14, 2011 at 1:55 am
Elliott Whitlow (7/13/2011)
If I remember correctly SQL 2005 SSIS won't let you step through the script. I seem to remember using MSGBOX a lot..CEWII
You do not remember correctly -...
July 13, 2011 at 9:49 am
Clearly I should stick to SSIS questions and leave this stuff to people who know what they're talking about 🙂
July 13, 2011 at 9:40 am
Of course. Set breakpoints and run interactively in BIDS.
Debugging a Script Component is not so easy ...
July 13, 2011 at 9:31 am
Just a single stored proc with four input parameters should be fine. Deal with the fact that some will be NULL in the logic of the proc.
If you will only...
July 13, 2011 at 9:06 am
Here is more detail. Some superb new features.
July 13, 2011 at 2:53 am
..and now it is magically working.
Merlin strikes again! 😀
Sometimes you just have to shrug your shoulders and get on with it rather than try to figure out why. I doubt...
July 12, 2011 at 7:44 am
Perhaps you could also try a system restore to when your system was working well - assuming you have a suitable restore point, of course.
July 12, 2011 at 7:21 am
This is not really the way that SSIS wants you to work.
It would be better if you could create a datasource which is your SELECT query.
Then put that into a...
July 11, 2011 at 6:09 am
The fact that the data shows up OK in the data viewer suggests to me that this is not a classic Excel-datatype issue, because it seems that the data is...
July 11, 2011 at 3:23 am
Try running just the Select part of the query and look for NULLs in the subisonum column.
That should show you which records are causing the issue.
July 8, 2011 at 9:39 am
but I want indexing for multiple variables where I can assign files to individual variables
Indexing? Please explain.
July 8, 2011 at 9:13 am
So am I right in thinking that you are attempting to use an Execute SQL task to retrieve a single figure and then to store that figure in a variable...
July 8, 2011 at 6:47 am
Viewing 15 posts - 11,236 through 11,250 (of 13,861 total)