Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bnejamin
Starting Member
2 Posts |
 Posted - 2008-04-08 : 07:59:05
|
| Hi there,I've been thrown in at the deep end at work and now I'm responsible for reporting from our databases even though I'm not qualified to do this in any way!I've created a view which ran successfully. I then created a package which successfully exported all the data to the excel file I had chosen. But now hwen I run it I get the error '2 tasks failed during execution, and a status of 'error occurred' for creating the table and copying the data.I would provide more details but I don't know what to show oyu or what will be of use.Many thanks for your help.Ben |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-08 : 08:02:49
|
| Could it be because the table is still there from the previous run?Rather than a view it's a lot more flexible to use a stored procedure as the source (and easier to develop).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bnejamin
Starting Member
2 Posts |
Posted - 2008-04-08 : 10:43:30
|
| Thanks for getting back to me. I'll have look at stored procedures and try them out.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-08 : 11:16:10
|
| After running what did the progress bar of package report? I think that should be start point of your investigation. Or have a look at sysdts90 table for the pckage run record. |
|
|
|
|
|
|
Problem with packages