Forum Replies Created
Viewing 13 posts - 1 through 13 (of 13 total)
-
RE: Send Mail Task issue
Hi,
Use profile name as "Exchange settings" instead of outlook in your send mail task. Then it will be ok.
-
RE: DTS Package running slow
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...
-
RE: DTS separate OK: In package error
Hi,
Try to specify the "max error count" property in "data movement" on options tab of Transform data task properties.
Regards,
Saravanan.
-
RE: Writing Exception Messages to File Log from Transform Data Task ActiveX
Hi,
Try to use file system object in your script and write your own exception file and send it to respective user.
Regards,
Saravanan.
-
RE: DTS for updating and inserting rows from MS-Access to sql server.
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...
-
RE: how to get error description in stored procedure
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.
-
RE: Simple issue of locking and checking problem. Please advise
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...
-
RE: Can find the solution
- LEFT JOIN
The result set of a left outer join includes all the rows from the left table specified in the LEFT OUTER...
- LEFT JOIN
-
RE: Can find the solution
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....
-
RE: Can find the solution
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...
-
RE: How to return DTS satus(fail or success) using command prompt utility
Hi John Laska,
Thanks for your suggestion. I will try that way.
Saravanan.
-
RE: Select Table Name using variable
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...
-
RE: Select Table Name using variable
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...
Viewing 13 posts - 1 through 13 (of 13 total)