Hi,
I use SQL Server 2005 version and I am trying to built a simple SSIS package
where I need to pass a variable with a preset value to a SQL command statement.
The whole purpose of the package is to select some data from the SQL server with a particular Jobno and then put it into an excel sheet.
Right now, I do not know how to pass a value to the variable(Jobno).
My package has a 'delete results table' task->'create results table' task->'Copy data to results' task.... All these in control flow..
When I double click,'Copy data to results' task... it moves to data flow..
where I have 'OLE DB Source'->'Data Conversion'->'Excel destination'
Now I need to pass the variable value(JobNo) to the 'OLE DB source' which selects data from SQL server.
How do I do this using OLE DB source? I have been reading articles which uses variable value in a package using Scripttask and Execute SQL task... but I want to do it using OLE DB source in data flow... Is that possible?
Is there a better way to do it?
Please advice.
Thanks.
I use SQL Server 2005 version and I am trying to built a simple SSIS package
where I need to pass a variable with a preset value to a SQL command statement.
The whole purpose of the package is to select some data from the SQL server with a particular Jobno and then put it into an excel sheet.
Right now, I do not know how to pass a value to the variable(Jobno).
My package has a 'delete results table' task->'create results table' task->'Copy data to results' task.... All these in control flow..
When I double click,'Copy data to results' task... it moves to data flow..
where I have 'OLE DB Source'->'Data Conversion'->'Excel destination'
Now I need to pass the variable value(JobNo) to the 'OLE DB source' which selects data from SQL server.
How do I do this using OLE DB source? I have been reading articles which uses variable value in a package using Scripttask and Execute SQL task... but I want to do it using OLE DB source in data flow... Is that possible?
Is there a better way to do it?
Please advice.
Thanks.
