September 11, 2009 at 9:26 am
I have created 7 .xls files from 7 different SSIS export wizards creating 7 packages. Its source is 7 Sp's in sql with 2 date parameters that I need to change into SSIS variables and set the values at run time (they are reportingEnd and Begin parameters).
ultimately, I want to use BIDS to recreate these 7 exports inside 7 sequence Control flow containers making it 1 package.
I want to create to variables @dtReportingBegin and @dtreportingEnd in each of the 7 data source stored procedures in their respective source data task flows . I then want to use the ,not sure what its called, but the window that opens when u right click a packake and select open to map to the 2 variables and assign values to them before running the package. Now assign values to variables and setting the path to them I have never done. I am hoping once i create them in the SSIS editor I will be able to find them from the execute window.
so the finished product would let us right click the package in the filesystem > select open and assign the to date values to the 2 date variables and just hit execute.
how does this sound?
September 16, 2009 at 5:29 pm
This is what I would do ....
1. Create SSIS package (put all the data flow in one dtsx)
2. Use variable for start date and end date
3. Create a simple form using VS and get variable using this form
4. Pass the variable and call SSIS package using VS
September 22, 2009 at 6:53 pm
Right path I think..
1. One SSIS package
2. 1 or more Dataflow components, it can be either, one is probably the easiest, no need for sequence containers.
3. Create start and end variables that will be used in the queries in the dataflow.
Now here I have questions..
What you were taking about is called the package configuration wizard.. Package configurations is great for data that is set and is not going to change very often. If you have date columns that are gonna change more than once per month then this is probably not the best method..
1. How is the package going to be called, xp_cmdshell, SQL Agent?
2. Is the server 32 or 64 bit?
3. How often will the start/end dates change?
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply