Viewing 15 posts - 9,166 through 9,180 (of 11,676 total)
sdvoranchik (7/13/2011)
select * from [download$]
where column1 = 'value'
You can use all of the regular sql syntax from here to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2011 at 12:44 am
The reason for the initial error is that a stored procedure doesn't have an explicit metadata contract, such as a view or a table-valued function. But SSIS does expect metadata...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2011 at 12:27 am
Phil Parkin (7/14/2011)
asranantha (7/14/2011)
plese solve this and send my mail id =asranantha@gmail.com
...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2011 at 12:23 am
You're probably doing something wrong 🙂
So you have a string variable at the package level which has the connectionstring as the value, right?
Is it hard-coded, or loaded by an expression...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2011 at 12:20 am
GBeezy (7/14/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2011 at 12:15 am
If your question is:
"How to found out how many rows we processed today with SSIS?""
You need to set up logging to investigate that. The standard SSIS logging only logs the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2011 at 12:12 am
Try using signed integers instead of the unsigned ones.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2011 at 12:07 am
Well there isn't anything out of the box to do that for you (yet, in Denali it will be possible).
So if you really want to generate the metadata, you'll need...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 11:47 pm
opc.three (7/14/2011)
From your presentation - hooray!> easy to diff package format
> relative path references
The first one I got from a quote from Matt Mason (developer on the SSIS team), the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 11:44 pm
Craig Farrell (7/14/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 11:38 pm
The method seems OK to me. Do you use package configurations to change the path at runtime?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 11:57 am
SanDroid (7/14/2011)
I have yet to see the M$ SQL environment where related Tables joined faster with no defined PK/FK relationships. 😛
Joins maybe (although I was under the impression that it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 11:32 am
David.Poole (7/14/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 11:30 am
opc.three (7/14/2011)
Phil Parkin (7/13/2011)
Here is more detail. Some superb new features.
The list of new features is impressive...lots of my past gripes have been addressed 🙂
Huge improvements for me:
> Load files...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 11:11 am
Coolroof (7/14/2011)
ITS RIGHTS..THIS IS MY QUERY
And this is you solving your problem on your own...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 7:11 am
Viewing 15 posts - 9,166 through 9,180 (of 11,676 total)