I dont think so..

I might be oversimplifying here but isn't it the case that products will have only one record for a particular product id and all the past records are written to...

as already mentioned, pls provide create table, insert data and expected results.

my attempt at the query--

with mycte as

( select row_number() over (partition by dt order by ds desc) as rowid,*

from asset)

select * from mycte

where rowid <> 1

thanks

Pankaj

why would you use cursor here when a simple update can do the job (as explained by Nabha)

any ways, did you get the job?

too much work and no play makes jack a dull boy. 🙂

Just being curious...wat exactly is your objective here..

what is your execute sql task trying to do...

as far as I can see you should be getting connection string properties (server/Dbname) from...

I would suggest to delete the present job and create a new one.

This should resolve the problem.

Pankaj

This is just for the sake of understanding the issue

You get multiple mails on 'OnError' because you are getting multiple errors in your package.

On each error, an email is triggered...

My table would not be a temp table it would be persistant.

Can you please explain how to use the bcp to export data to csv.

Thanks

I would be using a dynamic SQL code in a stored procedure to create the table i want to export.

My problem to is dynamically create the connection , metadata information...

ssexton,

It would really help if you could explain what exactly are you planning to achieve through the script.

What do you want your SSIS package to do?

Thanks

Pankaj

Answers to your questions below:

1)Yes

2)If you use On Delete Cascade on Orderdetails, any order deletion

from Ordersummary would result in deletion from Orderdetails.

3)Its primarily used for referential integrity i.e. to avoid...

i am using SQL server 2005. how do i store videos and images(.jpg)

on it?

Phil,

Thanks for your help.

Just got the answer to my question from the user. Its a Visual FoxPro file.

So it cant be imported without a driver installed?

Just wanted to sure before...