Viewing 15 posts - 3,211 through 3,225 (of 11,678 total)
What do you mean with "not correct"?
Why don't you use (n)varchar(max) for the column?
Another option is to use the filestream feature.
April 24, 2014 at 2:35 pm
Depends on the transactions you are doing and on the recovery model.
What is the recovery model?
April 24, 2014 at 2:30 pm
Seems like an issue loading the assemblies needed for VB.
Did you try a repair of BIDS? (bit of a long shot, I know)
I think this is the universe telling you...
April 24, 2014 at 2:25 pm
Very important thing to know: the RentalFeeAmount, how is this calculated? How is this used?
If it is a normal measure - additive and all that - option 1 is flat...
April 24, 2014 at 2:18 pm
+1 for surrogate keys into the fact table.
Very useful if you update facts.
Even if you only insert rows, it can be useful to have a surrogate key, for example to...
April 24, 2014 at 1:40 pm
Tony Sweet (4/24/2014)
The exception is if you are trying to manage SSAS through SSMS. I have found it requires the same version of SSMS as the version of SSAS.
I...
April 24, 2014 at 10:56 am
Unfortunately I can't see the screenshots (probably blocked by firewall), but I have installed multiple versions of SQL Server side by side without an issue.
It should be no problem to...
April 24, 2014 at 1:20 am
You can start the executions of packages also through a stored procedure. You can dump the value of the SSIS catalog executionID to a parameter in the package and...
April 24, 2014 at 1:08 am
twin.devil (4/24/2014)
Koen Verbeeck (4/24/2014)
SSIS expects a specific format.YYYY-MM-DD HH:MIS:SS
Just a thought really, In addition to Koen respone if your source is sql server, you can perform this convert on database...
April 24, 2014 at 12:43 am
It seems your caps lock is broken.
This thread lists some solutions to find the object that is referencing your function:
Find it and alter the code so that it stops referencing...
April 24, 2014 at 12:41 am
What exactly do you want to log withing the stored procedures?
Maybe you can execute them with Execute SQL Tasks?
April 24, 2014 at 12:34 am
Remember we cannot see what you can see/think.
It is not entirely clear what you want to achieve.
What do you mean with calculated fields? What is your source?
April 24, 2014 at 12:28 am
SSIS expects a specific format.
YYYY-MM-DD HH:MIS:SS
April 24, 2014 at 12:23 am
Another object is referencing your function. For example another function or stored procedure is using the function you want to drop. If you would drop it, it would break the...
April 24, 2014 at 12:21 am
Viewing 15 posts - 3,211 through 3,225 (of 11,678 total)