October 3, 2012 at 9:57 am
Hello Everyone, I am newbee to ssis. I was asked to create a SSIS Pacakage which contains parameterised report (say it contains a parameter called persons). I am supposed to get each person data in one excel stored in a folder and then stored in a drive.. can any one help me out with this
October 3, 2012 at 10:29 am
hearty (10/3/2012)
Hello Everyone, I am newbee to ssis. I was asked to create a SSIS Pacakage which contains parameterised report (say it contains a parameter called persons). I am supposed to get each person data in one excel stored in a folder and then stored in a drive.. can any one help me out with this
So you want your package to accept one parameter (let's call it PersonID) and then generate the required report and spit out an excel spreadsheet containing the data for that person and have it stored in directory on your local file system?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 3, 2012 at 10:47 am
Yes Exactly
October 3, 2012 at 1:47 pm
Not the easiest exercise to start your adventure with SSIS but this is possible to do yes.
1) Create a stored procedure which will accept your parameter (let's call it Employee ID)
2) In your sproc you will need to use xp_cmdshell to execute the package and pass the employee ID... Something like this:
set @SSISPackageLocation = 'C:\YourPackage.dtsx'
set @employeeid = 123456
select @cmd = 'dtexec /F "' + @SSISPackageLocation + '"'
select @cmd = @cmd + ' /SET \Package.Variables[User::employeeid].Properties[Value];"' + @employeeid + '"'
exec master..xp_cmdshell @cmd
3) Create the package.... I'm working on an example so will post later
Good luck!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply