Viewing 13 posts - 1 through 13 (of 13 total)
Hi,
Use profile name as "Exchange settings" instead of outlook in your send mail task. Then it will be ok.
Saravanan V
geocities.com
April 11, 2006 at 4:13 am
Hi,
Better check your Server configuration. If it is good then u can go for some other way.
Better write the data form DB2 into a Data file with delimiters and from...
Saravanan V
geocities.com
November 23, 2005 at 10:15 pm
Hi,
Try to specify the "max error count" property in "data movement" on options tab of Transform data task properties.
Regards,
Saravanan.
Saravanan V
geocities.com
November 20, 2005 at 10:24 pm
Hi,
Try to use file system object in your script and write your own exception file and send it to respective user.
Regards,
Saravanan.
Saravanan V
geocities.com
November 20, 2005 at 10:13 pm
Use Correlated Subqueries to solve the problem.
Using Correlated Subqueries, just match the source and target columns.
If rows exists, do the update else insert.
For this you can use sql task...
Saravanan V
geocities.com
November 17, 2005 at 12:58 am
Thanks friends, We r not in the same project. I don't know that, who is Gogula.
I try this in some other way.
Saravanan.
Saravanan V
geocities.com
November 16, 2005 at 10:29 pm
While locking u can identifiy the user session id of sql server. Then u can put the session id and lock details in an application collection. if the user B...
Saravanan V
geocities.com
November 16, 2005 at 4:32 am
The result set of a left outer join includes all the rows from the left table specified in the LEFT OUTER...
Saravanan V
geocities.com
November 16, 2005 at 4:20 am
Hi,
Try the following.
select distinct
lname,
count(request.id)
from request
left join change on request.id = change.req_id
left join user on request.userid = user.userid left join change_hist on change.id = change_hist.chg_id
I just changed the join condition....
Saravanan V
geocities.com
November 16, 2005 at 2:43 am
Hi,
Try to use the group by clause. Because u r going to get count. so try to use those columns in group by clause, whatever present in select list.
I...
Saravanan V
geocities.com
November 15, 2005 at 9:44 pm
Hi John Laska,
Thanks for your suggestion. I will try that way.
Saravanan.
Saravanan V
geocities.com
November 15, 2005 at 9:25 pm
Hi,
Try to put the table name with dbname.ownername
For example:
set @lSqlStatement = 'Select * from mydb.dbo.glpl' + @sdate + ' where brcode=102 '
Try like this. i hope that, this will...
Saravanan V
geocities.com
November 15, 2005 at 5:28 am
Hi,
Try to compose the sql statement in a variable and execute the sql statement using execute command.
Example:
declare lSqlStatement varchar(2000)
set lSqlStatement = 'Select * from ' + your date variable...
Saravanan V
geocities.com
November 15, 2005 at 4:10 am
Viewing 13 posts - 1 through 13 (of 13 total)