gunther.vanloco (3/27/2014)

---

I tried adding it but the column is empty and is not included in the output apprantly so no hash tag at the end

I also tried a space...

It is normal that the fielddelimiter (aka column delimiter) cannot be the...

You can only achieve wisdom if you know what you don't know. 😉

That's great. What is the problem?

Nice question, thanks.

What was the issue?

It simply means...

Try to write to a file on a local disk. See if that works.

If it is a permission issue, yes.

Give the proxy account the required permissions on the folder and you're good to go.

An easy check is to...

If it works in BIDS, but doesn't with Agent, it is in 90% of the cases a permission issue.

OK, than you just need to modify your WHERE clause.

You have WHERE DATEDIFF(DAY, Convert(DateTime, DATEDIFF(DAY, 0, DateCreated)),GETDATE()) <= 7, so this means datediff can return a number between 0 and...

What if you drop the TOP 7 clause?

The package should work without configurations.

For the missing connection: I would recreate the source component, test it and then deploy it back to the server.

For the file: I would check...

It might. If you change connections with those configurations.

tlally (3/26/2014)

---

IN the Data source properties of the job step both connections are visible the ole db and the csv so the job is seeing the connections. The SQL server...