Forum Replies Created

Viewing 15 posts - 1 through 15 (of 25 total)

  • RE: Using Cursors And Fetch

    I know this may be considered as blasphemy and I can barely believe I am suggesting this on here, but you could use a lightweight ORM like Dapper for CRUD...

  • RE: Using the Script Component With Multiple Outputs

    This is a good article for how to use a compenent that is very badly documented in Books Online and everywhere else. I used the Script Component transformation to "condense"...

  • RE: Readwrite variables in the Script Component Task

    You are exactly right - i want to compare a field in the current row to a calculated value from the previous row.

    I had actually tried something similar in a...

  • RE: instr function in Reporting Services 2005

    I've actually found my problem and it wasn't the instr function at all. That worked fine.

    It was a second condition in the IIF statement that was comparing an integer to...

  • RE: instr function in Reporting Services 2005

    Actually it is #Error i am getting not a blank.

    I'm thinking i may need to do some data type conversion in the expression.

  • RE: Export to Excel - removing linked report hyperlinks

    I'm struggling with the same issue. You mention you have a solution and a blog? Any chance of letting me know where I can see this info?

    Thanks in advance,

    Matt

  • RE: FTP Task - getting all files

    Thanks for letting me know.

  • RE: INSERT+UPDATE

    Thanks for the links. It's always useful to build up examples and best practices. I have actually merged using the first technique - pre sorting as the data is taken...

  • RE: INSERT+UPDATE

    day,

    i'm trying to do an update after doing a merge join. Surely the method you have described updates one row at a time? I've got millions of rows so this...

  • RE: Dynamic creation of flat file sources

    SSIS and utilising how to load and export dynamically isn't the most intuitive tool. I would suggest the two things you should start looking into are using variables (in the...

  • RE: Which book is best for advanced SSIS?

    Thanks for all comments. I know what you mean about it not being a reference - it isn't. But then again i've been using SSIS for a while and know...

  • RE: Which book is best for advanced SSIS?

    Just to let people know I have bought the Expert SQL Server 2005 Integration Services from Wrox. The review on Amazon for Professional SQL Server 2005 Integration Services didn't seem...

  • RE: Which book is best for advanced SSIS?

    Has no one bought a specialist book on SSIS? I find it hard to believe. Help is needed urgently.

  • RE: SQL Server 2005 v MySQL

    To be totally honest i'm not thinking of packing in the certification just because i won't use it on a day to day basis, but it will be harder than...

  • RE: SQL Server 2005 v MySQL

    I am a developer so from a point of view of how the servers are set up i haven't really been factoring it into my consideration. Apart from the fact...

Viewing 15 posts - 1 through 15 (of 25 total)