Viewing 15 posts - 5,416 through 5,430 (of 7,187 total)
Bhavika
I don't think so. The File System Task is for performing actions on files, not for manipulating data within files. I've never tried it, but you should be...
April 20, 2011 at 3:46 am
Subrat
"Am getting error" is not helpful. Please post the actual query and the error message.
John
April 20, 2011 at 1:48 am
Right-click anywhere on the design surface in your control flow in BIDS, and choose Package Configurations. Then follow the instructions I gave before.
John
April 19, 2011 at 8:34 am
Bhavika
Yes, you can use a package configuration in the child package. Choose Parent package variable from the Configuration type drop-down, and type in the name of the variable.
John
April 19, 2011 at 8:19 am
For the first problem, a DDL trigger should be what you need.
For the second problem, look up the syntax for ALTER LOGIN. You'll also need to use that in...
April 14, 2011 at 4:42 am
Clustered index and non clustered indexes? On what? Please post table and index DDL so that we can help you. Is this update a one-off, or something...
April 14, 2011 at 3:20 am
Timestamp, despite its name, is for row versioning and not for recording times of action. Create your column with datetime data type, and insert GETDATE() into it.
John
April 14, 2011 at 3:18 am
You need to do your update in two passes:
;WITH t1 AS (SELECT id,price,relatedid FROM trans)
UPDATE trans
SET price=(
SELECT AVG(price)
FROM t1
WHERE t1.id<=trans.id
)
WHERE relatedid IS NULL
;WITH t1 AS (SELECT id,price,relatedid FROM trans)
UPDATE trans
SET...
April 13, 2011 at 8:08 am
Please will you post your actual update statement, since the one you posted has two syntax errors in it.
Thanks
John
April 13, 2011 at 5:14 am
Sachin
It doesn't work like that. Gail, like me, does not get paid for providing answers on this forum, and she is just as likely as me to want to...
April 13, 2011 at 3:29 am
Sorry, but are you the original poster logging in under a different name? If you're not, please start a new thread. If you are, you've confused me, because...
April 13, 2011 at 3:09 am
Right. I'm not doing all your work for you. Have you searched for that error message? What else do you have installed on your server?
John
April 12, 2011 at 4:06 am
Sachin
I would concentrate on that line you mentioned in your original post. Have you searched the internet for it? What have you got installed on your T drive?
John
April 12, 2011 at 3:55 am
Sachin
That's the errorlog file, isn't it? I need SQLAGENT.OUT.
Thanks
John
April 12, 2011 at 3:46 am
Sachin
Please will you post the contents of your latest SQLAGENT.OUT file?
Thanks
John
April 12, 2011 at 3:38 am
Viewing 15 posts - 5,416 through 5,430 (of 7,187 total)