Forum Replies Created

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

  • RE: SSIS access denied problem

    I can't see any reason why this would help in this case, but I have generally had more success using UNC paths rather than mapped drives for jobs like this.

    November 14, 2011 at 11:39 am

    #1407454

  • RE: Appending 00 for column values

    Thanks Phil, well now I am beginning to know enough about SSIS to be a danger to myself and anyone around me.

    No problem!

    November 14, 2011 at 8:14 am

    #1407195

  • RE: Appending 00 for column values

    Hehe.

    Here's how it's done in SSIS.

    1) Add a data flow task.

    2) Add an OLEDB source connection to the DF.

    3) In the connection manager settings for the OLEDB source, select 'SQL...

    November 14, 2011 at 7:56 am

    #1407168

  • RE: Eliminate Loop and take a set-based approach

    Thanks for the extra detail - makes more sense now.

    If you want to avoid loops, you'll need to use the power of the database - and as the data is...

    November 13, 2011 at 2:05 pm

    #1406867

  • RE: Eliminate Loop and take a set-based approach

    I'll start off by saying that I am almost certain that no WHILE loop will be required here.

    But in order to get to a solution, I'll need to ask a...

    November 13, 2011 at 12:59 pm

    #1406856

  • 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.

    November 12, 2011 at 6:42 am

    #1406695

  • 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...

    November 12, 2011 at 4:02 am

    #1406664

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

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

    November 12, 2011 at 3:59 am

    #1406662

  • 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...

    November 10, 2011 at 10:58 am

    #1405937

  • 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...

    November 10, 2011 at 10:35 am

    #1405923

  • 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...

    November 10, 2011 at 2:28 am

    #1405570

  • 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...

    November 2, 2011 at 9:51 am

    #1402235

  • 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...

    November 2, 2011 at 6:43 am

    #1402110

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

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

    November 1, 2011 at 3:32 pm

    #1401904

  • 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...

    November 1, 2011 at 3:26 pm

    #1401900

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