Hi,
I want to create DTS package which can accept a parameter and export / import data which match the parameter value. is it possible? if yes , can you please tell me the steps.
thanks in advance.
Satya - do not refer me to SQLDTS.com , not much help there .
RamI am not clear on what you are trying to do...
What are the source and destination connections in both the import and export scenario.
Are you trying to conditionally import or export data based on some Parameter? How are you executing the package?
DTS packages can take input parameters and return paramters via Package Variables (inner and outer). You can use an Execute package task to pass parameters to a nested DTS package which contains your logic for import or export. Depending on the complexity of your process you could create one master package (to manage the process) and two "child" packages: one for Import and one for export.
See books online for more info on the Execute Package Task...
CPNsqlsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment