Viewing 15 posts - 841 through 855 (of 3,232 total)
I've done the same as Grant and Steve, although with a different source control tool. You have to build processes around your change control that everyone follows. Document...
December 14, 2009 at 12:01 pm
Given the new sample data that you've shown, what would you expect the results to look like?
December 14, 2009 at 11:42 am
This is a simple LEFT OUTER JOIN:
DECLARE @tableA TABLE (DealerId varchar(10), ISCI varchar(10))
DECLARE @tableB TABLE (DealerId varchar(10), ISCI varchar(10))
INSERT INTO @tableA
SELECT 's021','1234' UNION ALL
SELECT 's021','2354' UNION ALL
SELECT 's021','2564'
INSERT INTO @TableB
SELECT...
December 11, 2009 at 2:24 pm
What data source are you using to the the XML column into the pipeline?
December 11, 2009 at 2:20 pm
For the config file, only check the boxes of the items/variables that you want to be able to change from outside the package. I would imagine that most of...
December 11, 2009 at 2:08 pm
I want to capture that failure message for any failing script and email that output file to the user group.
If you've set up the script task inside the...
December 11, 2009 at 1:00 pm
I am stuck with the event handler part and send mail task !
Why the event handler has execute SQL task with a dummy statement ?
Also the variables you mentioned...
December 8, 2009 at 1:52 pm
First off, thanks for the detailed post. It is most helpful to know where you are at so we can make the appropriate adjustments and get you moving in...
December 3, 2009 at 2:46 am
Sorry for the delay on this, it kind of fell off my radar. The intent of my last question was to learn which control/data flow tasks you've used to...
December 2, 2009 at 3:49 pm
It was the correct answer for a question that was never asked. Based on your original post, how can we tell what you've already tried, where your problem lies,...
December 2, 2009 at 9:27 am
Go to the Master database, under Programmability>>System Stored Procedures and find sys.sp_who2. You can review the code.
December 1, 2009 at 1:17 pm
rahulsony111 (12/1/2009)
i should use a stored procedure cause it will be used very often
Once converted, it would not need done again. Just curious, why would this be something that...
December 1, 2009 at 1:01 pm
From SSMS, run sp_who2. This will show all connections to the SQL instance, which DB they are connected to, the host ID, application name, and all other connection related...
December 1, 2009 at 12:56 pm
In addition to what Sabya has said, maybe try to do this yourself and let us know where you need help. We're not here to do the work for...
December 1, 2009 at 12:19 pm
Viewing 15 posts - 841 through 855 (of 3,232 total)