Assign the "filename" to a DTS variable in a script task, then use the variable as the attachment and the path for the flat file destination.

rmechaber (12/21/2010)

---

Can you explain that more? How were you able to use SSIS to recover actions taken? Did you have the day's modifications stored in a flat file...

UPDATE mytable

SET column1 = 'test'

WHERE ABS(myid) % 2 = 1

Seems Dave was quicker off the draw than me 😉

To add to this, I had a similar issue not too long ago which was solved on this forum.

Try going over this.

Using Gianluca's sample data :

UPDATE #tmp_table

SET Diff = t2.Diff

FROM #tmp_table t1

INNER JOIN (

SELECT a.ID, a.Inv, a.Est, a.Inv-SUM(b.Est) AS Diff

FROM #tmp_table a

CROSS JOIN #tmp_table b

WHERE (b.ID <= a.ID)

GROUP BY a.ID,a.Est,a.Inv) t2

ON...

Backups used to be made regularly, but due to disk space it was turned off (not by me).

In the end, the tape disk was there, so I was able to...

Yes, well, I've spoken to the DBA (who is on sick leave) and we've decided that we'll be making...

Unfortunately not. Awesome. I'm hoping that we have a tape backup from last night, but with our Network Admin I'm hoping in vain.

Maybe they'll listen to me from now...

See below sample code. If you still need help, post your code.

DECLARE @ddmmyyy VARCHAR(MAX), @mmddyyy VARCHAR(MAX)

SET @ddmmyyy = '23/4/2010 0:00'

SET @mmddyyy = '4/23/2010 0:00'

SET DATEFORMAT dmy ...

You'll never get an accurate result from that table.

You could count all of the records that were during consecutive minutes, but what if it ran twice over 2 minutes?

E.G.

Run 1...

stricknyn (12/1/2010)

---

Hi,

Is there a way you can have the primary key output from the system that produces the error file? This would essentially solve your problem. If the...

Thanks a lot everyone. I had Jeff's article marked down as something that would probably benefit this, but to be honest I haven't got around to it yet (guess what...

Assuming I've understood what you've asked for: -

WHERE [Admission Method (Hospital Provider Spell)] in ('11','12','13','31','32','81','82','83','21','22','23','24','28')

If this isn't what you want, then please read the link in my signature.

(note: there may be a better way of doing this)

DECLARE @TABLE AS TABLE(

ID INT IDENTITY,

InTime DATETIME,

OutTime DATETIME)

INSERT...

Still, it's a presentation layer task rather than a DB task, as you pointed out.