Forum Replies Created

Viewing 15 posts - 11,041 through 11,055 (of 13,872 total)

  • RE: How to get query result in .CSV file with UTF-8 format.

    It seems that you are not the first to come across this problem. Take a look here and see whether it might be relevant.

  • RE: ssis and ssrs interview questions

    Jeff Moden (11/11/2011)


    Gosh... I went back and looked at one of the links for SQL Server questions and answers. Part of the reason that I recommend NOT using such...

  • RE: Loop Keyword in SQL SERVER-BY-SHUBHAM SAXENA @INVENTIVE INFORMATICS

    Not sure I understand. How is this related to SSIS?

  • RE: ETL Design

    Note to OP: sorry for hijacking your thread 🙂

    Morocco is hectic and chaotic. An interesting place, with some excellent people and many more who are just trying to separate me...

  • RE: ETL Design

    Koen Verbeeck (11/10/2011)


    Phil Parkin (11/10/2011)


    kramaswamy (11/8/2011)


    IF there isn't a huge amount of logic being used to transfer the data, maybe you could use a foreach loop, and have a table...

  • RE: ETL Design

    kramaswamy (11/8/2011)


    IF there isn't a huge amount of logic being used to transfer the data, maybe you could use a foreach loop, and have a table which has the names...

  • RE: Advice on update

    luismarinaray (11/2/2011)


    Hi,

    How do you update a group of records with the following "features",

    By each group, update every record, with a counter which has to begin from 1 for each group.

    I...

  • RE: Subquery With Aggregates and Pivot

    Many of the headings are dynamic based on the current date, e,g, 2010 (Last Year), Year To Date (2011 YTD), Month to Date (MTD), Last Month (Sep 2011), etc.

    I'll just...

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    No problem and good luck. Please post back when you get the problem resolved.

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    OK, that is weird. If it were me, I'd start thinking about deleting that FTP task and putting in another (with exactly the same settings/config, of course). Sometimes, it's as...

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    Ten-second lesson: click once on the FTP task to select it and then hit F9 to set the breakpoint, which will appear as a red dot.

    Execution should now pause...

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    Can you put a pre-execute breakpoint on the FTP task to check its properties at run-time?

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    At what point is this error appearing? Is it during package execution, or when the package is firing up and validating?

  • RE: BIDS 2008 and SSIS 2005 packages question

    I use the version of BIDS that came with SQL 2008 R2 Dev Edition to build and edit SSIS packages that get deployed to SQL 2005 Standard Edition servers. Works...

  • RE: Cann't run SSIS package using sql agent.

    Hmm, I'm no DBA:-) This might help:

    SELECT * FROM fn_my_permissions('msdb.dbo.sp_ssis_getpackage', 'OBJECT')

    where permission_name = 'EXECUTE'

    If it returns a row, you should have EXECUTE permission. If not, you might have to GRANT...

Viewing 15 posts - 11,041 through 11,055 (of 13,872 total)