Hi
I have an application like fetching records from the DataBase(MS Access 2000) and results i have to use in Script Task. At present i have used the record fetching query,connection string in Script itself. I would like to use in Independently. Is there any Tools like (Control Flow Tools like Execute SQL Task) are there to fetch the result set from Acccess and can use the fetching results in Script Task....
Thanks & Regards
Deepu M.I
How to Fetch the Recrods from MS Access and using it in Script Task Using Control Flow Tools(Execute SQL Task)
LittleG
Hi Jamie
My application is very simple i want to read some data from MSAccess.
Normal Select Query like (Select * from tablename").
I want to access this records in Script Task.... Which tool i can use for this
and How to get the records in Script Task.
Regards
Deepu M.I
Art Johnson
Hello,
Yes, you can achieve this by loading the data into an ADO recordset using the Recordset Destination Adapter. This adapter loads the data into a variable which you can then access inside a script task.
There is some code here that shows how to access data stored in a recordset: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx
This code is for a script component but the same basically applies for a script task.
-Jamie
Manik_Mahajan_3112ff
Hi Jamie
The above link I have tried its not happening. Script Task showing some error.
Is there any other solutions for this.....Can u Please help me...
Regards
Deepu M.I
Dacryphil
Without meaning to sound rude, I have already told you a way to do it. Did you follow the instructions in the post that I linked to above
-Jamie
Anonymous1673443
What's the error
What's your code
Help us to help you. We're not psychic!
-Jamie