By 'fails', do you mean that zero records are retrieved?

There is probably a way of achieving this by using a conditional split based on record count (0 is one path,...

Great stuff & thanks for posting back - perfect use of these forums.

Not a stupid question at all 🙂

Try createinga solution and adding the package. Then work with the solution, rather than editing the package directly ...

When the error is reported, is it because the exe has failed (ie, the text files truly do not exist), or is it that the text file is in the...

Maybe this thread is relevant:

http://www.sqlservercentral.com/Forums/Topic746185-148-1.aspx

What do you mean by 'empty' exactly?

a) No file

b) File exists, but no data or meta data in it

c) File exists, column headings exist, but no data rows

d) Something else?

Are you asking for how to automatically deal with structure changes to source files (eg, change in number of fields, max length of fields or data types of fields)?

Or how...

Indeed, no doubt classed as a feature 🙂

Eek. Stop all activity on your PC and find an undelete app from somewhere, after first checking that the DTSX file is not magically in your Recycle bin.

You should also...

I am afraid I have no idea what could be happening, it all sounds very straightforward.

Does it always process exactly the same number of records? If yes, try putting an...

Thank you Allen - I was looking particularly healthy and radiant the day that one was taken :w00t:

When you modify a package in BIDS, you are probably updating a version...

While it may well be your company's policy to do this, it is not mandatory.

It is perfectly possible to create a SQL Agent job to run a package which exists...

phumlo1 (7/22/2009)

---

Hi all,

I am using an OLE DB Source in an SSIS package I inject sql script below to retrieve data from datasource. The source has 700 000 records but...

In an Execute SQL task, if you want to build a dynamic piece of SQL that includes variables, use the 'Expressions' area to override the SQLStatementSource property & this should...

There is perhaps a more elegant way of achieving what you want - check out "Creating Package Configurations" in BOL.

You could have a variable called (say) LoadDate which is assigned...