Viewing 15 posts - 1 through 15 (of 25 total)
If you can open the solution in Visual studio editor (SSDT) and right click the package name in the solution explorer, then click View Code, it gives you the xml...
January 18, 2017 at 6:13 am
Sean Lange (7/13/2016)
Mohit Dhiman (7/13/2016)
Wonder why they always used to tell...
July 14, 2016 at 4:32 am
Even with the primary clustered key, are we sure here that the select always returns 2 at the last?
Wonder why they always used to tell us there is no...
July 13, 2016 at 8:06 am
I certainly have faced this problem, but apart from restarting Visual studio anything else really didn't work..
Oddly enough many a times even restarting VS did not help..
July 13, 2016 at 4:45 am
So, inside a data flow task, on an OLEDB source, if you select SQL command as the data access mode and click the Parameters button you can pass value/s to...
July 11, 2016 at 8:27 am
mister.magoo (1/9/2013)
Use your...
July 11, 2016 at 7:54 am
3 - variable is used as ? in sq statement as param -- DOES NOT WORK
Can't see why this should not work. Which version of SSIS are you doing this...
July 11, 2016 at 3:16 am
Not sure how you would do that with the Import/Export wizard.. Even if you manage to (assuming excel is still the source) you'll run in to the same error again...
July 11, 2016 at 3:06 am
You need to have a RowNumber/Rank in your date table that assigns each date with a sequence no.. Often it can be achieved with an identity column, but then you...
July 8, 2016 at 6:59 am
compufreak (10/20/2014)
Hi Mohityes i understand what you are saying but this is like really complicated as we pull data from all different tables joining it by a common ID.
Ok..but what...
October 20, 2014 at 12:56 am
.
October 20, 2014 at 12:47 am
If you are using a LEFT Join with a restricting WHERE then you need to be careful that your WHERE condition does not remove the additional rows your LEFT join...
October 20, 2014 at 12:45 am
What decides prj(5616) is to be called soccer?
I mean i thought you wanted to extract prj from prj(5616), but this is something else you are talking about.
Anyways, you could use...
October 20, 2014 at 12:32 am
Check the DB connection in the Connection Manager.. There's an option "Test Connection"..
If that works you should not be seeing this error.
October 17, 2014 at 4:09 am
Would have been better if you gave the values (some sample execution values) you were getting error for..
That would have helped in pin pointing the error..
Thanks
October 8, 2014 at 9:18 pm
Viewing 15 posts - 1 through 15 (of 25 total)