Viewing 8 posts - 1 through 8 (of 8 total)
Hi
I m using explicit username and pwds .
Thanks
Gomz
October 24, 2009 at 9:41 pm
Hi Elliot
I solved my problem using the Data Flow task itself.
1. Created a store proc that accepts an input
2. Called the store proc in OLE DB Source...
October 24, 2009 at 4:55 pm
Hi Elliot
Thank you for getting back to me.
From what I could see the Script task is best used when there are insertions to be made to a table....
October 24, 2009 at 10:56 am
Hi elliot
I m sorry for not getting back , the problem i faced was i needed to get the package variable into a ole db source so that I...
October 24, 2009 at 10:41 am
Hi Elliot
Thank you for replying.
I discovered that what I needed was to pass the SSIS variable to an SQL statement in an 'OLE DB Source'
I am not using...
October 14, 2009 at 3:58 pm
Hi I fixed my problem.
Instead of using a OLE DB Command , I used an OLE DB Source - configured the source to access a stored procedure that executes my...
September 29, 2009 at 8:50 am
Hi
The problem I m facing is how to map the output of my OLE DB COMMAND to the flat file destination ?
Thanks
Gomz
September 28, 2009 at 1:09 pm
Thank you very much for your prompt replies , I was able to use OLE DB Command to get what I wanted thanks to u both.
September 17, 2009 at 10:09 pm
Viewing 8 posts - 1 through 8 (of 8 total)