Post reply

Variables

  • January 20, 2014 at 2:24 pm

    #281269

    I'm semi-new to SSIS and I understand the concept of variables but I am not sure how to use them. Does anyone know of any tutorials? I've found a few on YouTube so far but I'm just curious as to past experiences when it came to learning how to use variables.

  • January 20, 2014 at 2:33 pm

    #1681674

    Here's an article that might help you. It's part of a Stairway Series and I recommend you to read the complete series 😉

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/99720/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • January 20, 2014 at 3:09 pm

    #1681684

    Narly254 (1/20/2014)

    I'm semi-new to SSIS and I understand the concept of variables but I am not sure how to use them. Does anyone know of any tutorials? I've found a few on YouTube so far but I'm just curious as to past experiences when it came to learning how to use variables.

    I suggest that you read a basic tutorial like - [/url]

    After that, look for ETL examples. Its highly likely that you will have to use variables. Then, you can learn more than just variables.

    Try this example - Select any data from SQL server into a result set (hint SSIS Object) and use a script task to write it to a file.

  • January 20, 2014 at 3:26 pm

    #1681687

    blasto_max (1/20/2014)

    Try this example - Select any data from SQL server into a result set (hint SSIS Object) and use a script task to write it to a file.

    To write to a file, there's no need to use a script task. You just need a data flow with a flat file destination. 🙂

    If you want to save the information for a specific period of time and save it into a file with a descriptive name (e.g. Sales of the day to Sales_yyyymmdd.csv) you can still do it without SSIS variables, but with the help of an expression.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • January 20, 2014 at 3:28 pm

    #1681688

    This is extremely informative, thank you!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply