As I said before, one row isn't particulary useful. And the header row is totally useless since I can't tell where one column name ends and the next begins....

You've only sent one row, so I can't see what repeating patterns there are. What I can see in the row you pasted is that each column is separated...

Well, if spaces occur only between columns, and not within them, I suppose you could do a find and replace, and put an appropriate delimiter in place of all spaces....

If the columns aren't delimited, are they fixed width? In other words, does each column begin at a specfied place on the line? If your file isn't delimited...

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...

Subrat

"Am getting error" is not helpful. Please post the actual query and the error message.

John

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

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

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...

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...

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

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...

Please will you post your actual update statement, since the one you posted has two syntax errors in it.

Thanks

John

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...

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...