Viewing 15 posts - 151 through 165 (of 2,267 total)
add the row count transformation to the respective data flow, assign the results to seperate variables and use the variable to reference to row count.
October 11, 2011 at 4:21 am
I guess since most DB developers are not actually engineering software.
I would consider a software engineer to be someone that writes low-level code.
Though I wouldn't worry too much about Job...
October 11, 2011 at 4:19 am
I dont think a poll of Four people is really going to tell you anything, give it some time maybe..
October 10, 2011 at 8:35 am
is sp_who2 still undocumented?
as i use that all the time.
Also DBCC Page now and again..
October 10, 2011 at 8:15 am
Dev @ +91 973 913 6683 (10/10/2011)
There are many guys who blindly follow the recommendations given by experts (like you). They are generally accidental...
October 10, 2011 at 6:54 am
Precendence constraints should be able to work for this, have you checked that you have the 'Logical AND' option select under the Multiple Constraints section in the Constraint...
October 9, 2011 at 1:43 pm
Can you explain a bit more about what you want to acheive?
October 9, 2011 at 1:35 pm
is there any chance you can run a trace against SQL server to see what SSIS is throwing at it?
if so then you should be able to work out...
October 6, 2011 at 10:00 am
Have you tried the SAS OLE db provider.
October 6, 2011 at 9:45 am
sorry i was thinking of the datatypes in the execute SQL tasks.
yes I think you convert the unique ID to varchar for the query.
October 6, 2011 at 9:22 am
Charmer (10/6/2011)
i tried, but im bad at coding part....could you help me by showing some sample codings
haev you got the other increment working?
I can put something together, but wont be...
October 6, 2011 at 6:06 am
Phil Parkin (10/6/2011)
steveb. (10/6/2011)
Raunak Jhawar (10/6/2011)
Phil Parkin (10/6/2011)
Raunak Jhawar (10/6/2011)
If SQL 2008 and upwards...please follow the link herePlease describe how to use that within an SSIS package.
Execute SQL Task/Script...
October 6, 2011 at 4:46 am
Raunak Jhawar (10/6/2011)
Phil Parkin (10/6/2011)
Raunak Jhawar (10/6/2011)
If SQL 2008 and upwards...please follow the link herePlease describe how to use that within an SSIS package.
Execute SQL Task/Script Task
This is the 2005...
October 6, 2011 at 4:31 am
Follow the example in the link but for dates use the AddDays method of the DateTime classs.
October 6, 2011 at 4:28 am
RonKyle (10/6/2011)
Yes, I set them both to UnsignedInt, since there's no possibility of a negative number.
Have you checked the values in the cube to see if they are accurate? ...
October 6, 2011 at 4:03 am
Viewing 15 posts - 151 through 165 (of 2,267 total)