Is the report still rendered in HTML?

Good that you found the issue and posted it back. It can help other people who stumble upon this thread.

Can't you specify another path in the source query? Or use a variable in a derived column to add the destination path to the flow?

Please do not crosspost. It wastes peoples time and fragments replies.

I responded in your other thread:

http://www.sqlservercentral.com/Forums/Topic1536210-364-1.aspx

Are the amount of columns the same? Is the flat file delimited or fixed width?

Thank goodness logic still prevails 😀

Good question, thanks.

We would be able to help if you would post the entire CREATE PROC statement, not just the first line. My guess is that you still forgot to put SELECT...

No.

The error talks about CONVERT. Your posted code doesn't contain CONVERT.

You forgot the SELECT and didn't declare the variable.

edit: and if you want to see the effect of the formatting, you should convert to string.

roryoflynn1 (1/29/2014)

---

Hi there,

yes I have used konesans in the past and it is a great solution, unfortunately a lot of organisations will not accept it on their systems as the...

You can convert the data type in the source query itself.

What if you set DelayValidation to true on the package and the data flow?

That way the connection is validated when it is used for the first time (probably when the...

Do the SSIS packages launch any SQL queries against the source database?

Maybe you can run Profiler while the SSIS packages are running to find out what is going on.

Are you sure they are db_owner?

This error means the user doesn't have the VIEW DEFINITION or ALTER TABLE permission.

Table <Tablename> is set to read only, user doesn't have enough rights...

If the source data is numeric, just leave as it is. Don't use the data conversion component.

The excel file, is it a blank file or is there already data in...