Viewing 15 posts - 61 through 75 (of 153 total)
1) Right click on Sql Server in Sql Management Studio (SMS) -> Connections -> Allow remote connections
2) Right click on Sql Server in Sql Management Studio (SMS) -> Security ->...
March 4, 2013 at 12:32 am
I did it actually.....
But i have to run the same query on 5 servers and send mails. Instead of 5 mails i need to send 1 mail.
A single mail that...
November 29, 2011 at 6:40 am
I will get the following result as single row
<html><head><style type="text/css">caption {background: white;font:bold 10pt Calibri, Arial;} td {border:solid #cccccc 1px;font:9pt...
November 29, 2011 at 3:31 am
Hi,
my SQL statements are following
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Declare
@Recipients varchar(max) ,
@ProfileName sysname,
...
November 29, 2011 at 12:28 am
I tried with Lookup and not able to get this.
I did the following in my Package
Data Flow task1
...
September 8, 2011 at 3:38 pm
Thanks....
How do i import data into Tabl2 from Fil2 in For each loop for particular RefNo
Suppose data set has 10 ref no's
For first iteration refNo is 1123
In this...
September 8, 2011 at 1:51 pm
Thanks kramaswamy...
Could you please give a little bit more info on following statement in-brief
Connect this data flow task to another data flow task. In this one, you're again using a...
September 7, 2011 at 11:27 am
Hi Phil,
Thanks for info.
Its fixed width file only....
August 29, 2011 at 10:22 pm
Thanks for response.
Yes...
The first is Execute SQL task and next is SCript task...Then after this Process task will execute the batch file.
When i execute it by double clicking it prompt...
April 19, 2011 at 9:39 am
Thanks for Info...
I developed in BIDS 2005. BUt the UAT & Production are 2008.
I did the changes by open the Package with notepad and replaced the SQLNCLI.1 Provider with...
February 22, 2011 at 12:49 am
Thanks for response...
The following solved my issue...MAx Degree of Parellellism..
OPTION(MAXDOP 1);
February 6, 2011 at 11:47 pm
Instead of the above code why dont u use the following code...
Insert into employeedetails(empname)
Select @empname1 Union
Select @empname2 Union
Select @empname3 Union
Select @empname4 Union
Select @empname5 Union
Select 'Abc' Union
Select 'Def' Union
Select 'Ghi' Union
Select...
February 2, 2011 at 2:09 am
Thanks...i got it...
I had changed the package variables from String to int
and
used the following query to assign sql server date to the package variables
Declare @mon INT,@day INT
SET...
January 28, 2011 at 1:02 am
Thanks...
How to handle the following error while i am going to start a job?
Msg 22022, Level 16, State 1, Line 0
SQLServerAgent Error: Request to run job testing_sample_SSIS (from User sa)...
January 27, 2011 at 6:22 am
Hi,
U can declare a variable & and use "coalesce" or "ISNULL".
U can get in Comma seperated by using "coalesce" or "ISNULL"
Declare @var Varchar(MAX)
CREATE Table #temp (id int identity(1,1),Name VARCHAR(10))
INSERT INTO...
January 9, 2011 at 10:59 pm
Viewing 15 posts - 61 through 75 (of 153 total)