Hi, I found that after an install the permissions in the MDX SBS folder and below were not set to inherit same permissions as the parent Microsoft Press. Changing this...

Are you using a for each loop container to loop through and if so you need to have fully qualified path set rather than filename only?

If not, sorry, but...

Hi,

Could it be the syntax of your code should be select max(id) as id from tbl_1? I think you are setting the table alias 'id' to the SSIS variable rather...

Hi,

Have you tried setting the error output on the table read in itself(rather than Event Handler). You can change the particular column that failed to 'redirect row' after which you...

You have to open the solution(.soln file) in Visual Studio rather than (what I suspect you did) right click and edit the dtsx directly. You can only debug the solution.

Good luck!

You should be able to start SQL Server Business Intelligence Development Studio and then from pmenu select File->New->Project. There you should see Business Intelligence Projects under Project Types and under...

Hi Monisha,

To me it sounds as though the ODBC source needs configuring rather than SSIS. Have you tried changing the port number in the ODBC DSN configuration to the port...

You could pre process the files using Perl for which would easily filter out the useless info and output to fresh files with meta info in the first line. It...