Does the connection manager for the flat file have the column that you want to leave out? My guess is that by selecting ignore on the mapping in the...

Does the user that is running the job in SQL Agent have access to the network location? If you don't change the runas settings, then that user will be...

This doesn't seem to have anything to do with Integration Services. But I will try to answer.

I would think that your query would be something like:

select sum(...

It looks to me like the problem is between the web site and the database, the first step in the process, not the SSIS part. Is the data being...

There is a code page setting on the flat file connection manager. It is on the first page of the properties for the flat file. It should be...

If you paste "C:\aa\aa" in Run, you are able to browse to that folder? And whatever you want to do in that folder (write to it, read from it)...

Does it work when you are using BIDS then fail when using SQL Agent?

This will convert your file into result sets that you could load into a database. What I would do is to convert it to a stored procedure.

I added the...

Take a look at http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7f89f61a-1fd3-41d2-903b-949c8e989f1c/

You can use a Substring method to send only number of characters that your output column can hold.

I can't say for sure (I'm a developer), but I think that services still run when your machine is locked.

Are you talking about the log file generated by SSIS or a log file that is the data source in your dataflow?

First of all, data in SQL is unordered. Unless you have some element by which the data can be ordered, it cannot be ordered.

What I would do is to...

To get the number of rows affected is easy. You create an integer variable at the package level for each DataFlow task that you have. Then you add...

Thank you!

😀

Is this a tip or a question?