Viewing 15 posts - 9,046 through 9,060 (of 11,678 total)
Phil Parkin (8/9/2011)
Elliott Whitlow (8/9/2011)
Phil Parkin (8/9/2011)
Elliott Whitlow (8/9/2011)
August 9, 2011 at 11:42 am
Elliott Whitlow (8/9/2011)
Phil Parkin (8/9/2011)
Elliott Whitlow (8/9/2011)
August 9, 2011 at 11:40 am
Grant Fritchey (8/9/2011)
mazzz (8/9/2011)
I spotted this drinking establishment during a fleeting visit to Bradford, UK, and thought of this thread...
Anytime we're in Bradford, I have a pub selected. The only...
August 9, 2011 at 5:17 am
Duplicate post. Please read original thread with replies here:
http://www.sqlservercentral.com/Forums/Topic1155393-147-1.aspx
Please do not crosspost. It wasted people's time and fragments replies.
August 9, 2011 at 2:02 am
sqlusers (8/8/2011)
Can you try with the below one.Go to Package Properties and then Go to Security Tab and then Change the Protection Level to "EncryptSensitiveWithUserKey"
I wouldn't do that. Encrypting all...
August 9, 2011 at 2:01 am
First of all, don't use the OLE DB command in the dataflow. It is slow.
If you do the aggregation in the source query, as Phil suggested, it will probably have...
August 9, 2011 at 1:56 am
ASCII 0 is equal to NULL, apparently.
If it bothers you, you can do a REPLACE(mySTring, CHAR(0), '').
August 9, 2011 at 1:53 am
You can add a rowcount in your dataflow. (this stores the result in a variable)
Then, after the dataflow, you can use the variable value in an expression on the precedence...
August 9, 2011 at 1:52 am
I'd suggest you'd read the Datawarehouse Toolkit by Ralph Kimball on how to design/model a data warehouse.
Once you've modeled it as a star/snowflake schema, you can populate it with data...
August 9, 2011 at 1:49 am
So the variables are empy.
How do they get populated?
August 9, 2011 at 1:03 am
Is the application name necessary?
The servername is empty, is that because the variables are also empty?
Try the following format for the server name:
TCP:myServerName,port
August 8, 2011 at 6:53 am
Lynn Pettis (8/8/2011)
@SQLFRNDZ (8/8/2011)
I understood Lynn, that I did not mention any where that I want to become MVP.
Actually, you did:
@SQLFRNDZ (8/5/2011)
Thanks Kraig and I will be an upcoming...
August 8, 2011 at 6:16 am
@SQLFRNDZ (8/8/2011)
... I did not mention any where that I want to become MVP.
@SQLFRNDZ (8/8/2011)
August 8, 2011 at 6:15 am
Viewing 15 posts - 9,046 through 9,060 (of 11,678 total)