January 20, 2014 at 2:24 pm
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
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/
January 20, 2014 at 3:09 pm
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
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.
January 20, 2014 at 3:28 pm
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