Hi:
I am a beginner at SSIS subjects, i have a data stored at DataReader Destination and i want continue working whit the data. Somebody can help me?
Regards. deniscuba
What exactly do you want to do with the data?
Why have you used a datareader destination?
If you really do want to use the data made available from the datareader destination then perhaps this article will help: http://msdn2.microsoft.com/zh-cn/library/ms135917.aspx
-Jamie
|||DataReader Destination
(http://msdn2.microsoft.com/en-us/library/ms140291(SQL.90).aspx)
Loading the Output of a Package
(http://msdn2.microsoft.com/en-us/library/ms135917.aspx)
Defining Datasets for Package Data from SQL Server Integration Services
(http://msdn2.microsoft.com/en-us/library/ms159215.aspx)
Normally you would use DtsClient (see Loading the Output of a Package above). You can also write your own consumer if you really wanted to, for example I have written a managed provider, so we can chain packages together, package 1 terminates in a DataReader Destination, package 2 starts with a DataReader Source that is pointed at the package 1. Not something you would normally do, but it suits our requirements.
No comments:
Post a Comment