Variables
-
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.
-
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/
-
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.
-
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.
-
This is extremely informative, thank you!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply