Viewing 15 posts - 10,906 through 10,920 (of 13,877 total)
mmiller 85218 (2/6/2012)
I need results as they show in my first post. So the actual combination of the different possiblities.
Your earlier post states this:
Ok, so lets assume that CatID...
February 6, 2012 at 9:45 am
CozyRoc (2/6/2012)
Shaheen,I will leave the translation of the code from VB.NET to C# to you. The code is very similar.
You may find this [/url]code-translation site useful.
February 6, 2012 at 7:55 am
Is this a school project or something?
Whoever made that requirement needs to justify it.
February 6, 2012 at 2:41 am
nhimabindhu (2/6/2012)
without using the query .Means using oledb source and aggregate tranfomations i need to send to destination .Not using that query in execute task or in oledb source
Please explain...
February 6, 2012 at 2:31 am
Thank you very much for the responses - I'll look into the partition switching idea.
Phil
February 2, 2012 at 11:08 am
Gazareth (2/2/2012)
Although if you're doing all that, I wonder why SSIS would be used at all in this case.
Surely at that point SSIS has...
February 2, 2012 at 7:03 am
Koen Verbeeck (2/2/2012)
Phil Parkin (2/2/2012)
There's no such thing as reusable functions in SSIS ...
That's not quite true, though it certainly isn't as easy as it might be. If you...
February 2, 2012 at 7:01 am
There's no such thing as reusable functions in SSIS ...
That's not quite true, though it certainly isn't as easy as it might be. If you are prepared to venture...
February 2, 2012 at 6:42 am
So you are just ignoring almost all of the advice everyone has given you and still asking for help?
If you are not prepared to listen, or at least to...
February 2, 2012 at 4:37 am
Not sure, but have you tried using an expression, rather than parameters, to do this? Then you can quite clearly see where your variables are going.
You could also try something...
February 1, 2012 at 1:06 pm
rishiextc (2/1/2012)
1. SET IDENTITY_INSERT Table_name ON
2. INSERT into Table_Name (Column_1, Column_2......) Values (Value_1, Value_2.....)
(make sure while inserting you specify name of required...
February 1, 2012 at 7:34 am
That's how IDENTITY columns work. Read more here.
If you really want to reset the seed value, read up on DBCC Checkident.
February 1, 2012 at 6:54 am
If you rewrite your proc slightly to use dynamic SQL in the non-validating bits, you can get round the validation issues.
February 1, 2012 at 4:59 am
Once you've built your dynamic SQL string, try doing a straight
select @sql
before executing it. That should allow you to see where things are going wrong.
February 1, 2012 at 2:50 am
Viewing 15 posts - 10,906 through 10,920 (of 13,877 total)