A script component would also be able to do the job (read the lines, form a single record, then output it).

sachinrshetty (6/3/2010)

---

Hi all,

I found the answer in some blog and here it is

"My answer was always "Set RetainSameConnection=TRUE on the connection manager and set DelayValidation=TRUE on all tasks that use...

I do not think that this is the correct way to set up a transaction for what you are trying to do.

Try removing the BEGIN and COMMIT SQL tasks and...

What is your question?

What is this, some sort of examination?

You can also use T-SQL (some dedication needed!) to get file listings. Check out this link[/url].

I am thinking that it should be possible to send file name and creation date...

imani_technology (5/27/2010)

---

I have two variables: varNewPeriod and varCurrentPeriod. If varNewPeriod > varCurrentPeriod, I want to build a string and run it in a certain Execute Process Task within...

I'm sure that we can find something.

Can you give us an idea of what you're doing and why it has to be in script?

When you remote in to the server, do you use the same network login credentials as you use on your local PC?

Does it work if you run the batch file outside of SSIS while remoted in?

stewartc-708166 (5/26/2010)

---

In SSIS, data flow task, there is an XML data source that you could use for this.

To update the XML file (or create a new file) you could use...

Bravo - you beat me to it 🙂

sachinrshetty (5/26/2010)

---

Hi,

Phil Parkin, da-zero, skcadavre

Your query works fine but since Time column has datetime value if i use '=' operator it fetches only rows having...

This is the way to calculate 'yesterday' in an Access query:

DateAdd("d",-1,Date())

Surely this is a T-SQL question, not SSIS?