June 10, 2009 at 2:19 am
Hi experts...
i'm creating the ssis package programitically, i've succeeded in creating the package, adding the control task and data task, but not able to add the source and destination tables along with the columns. I've stored all the details in a XML file, only thing is i need to fetch the data from the xml file and feed it into the ssis package.
can any one please guide me how to achieve this task...
with regards
Murali...
*He that is good with hammer tends to think every thing is a nail*
July 1, 2009 at 7:24 pm
How about turning on package configurations in the package and having it read the XML file. I must say though that the xml file structure is defined by SSIS and not by YOU..
CEWII
July 13, 2009 at 2:41 am
Dear sir, happy to receive your reply, i was off for a week so i could not reply my apologies, if you wish i would like to elaborate my query and make it understandable to you, so that i can get the answer.
coming to the problem
i've created a package dynamically using a console application, with 2 table names hard coded, i'm able to execute the package successfully but the problem is the data is not getting transferred between tables, i'm getting all the columns of the source table as an output. wher am i going wrong, will you plz help me.
if i can acheive this i'll move forward with the xml file.
Thanks & regards
murali..
*He that is good with hammer tends to think every thing is a nail*
July 13, 2009 at 5:54 pm
Have you setup the pipeline between them? What you might do is build the package and then save it from the object model to a DTSX file and open it and see what exactly it built, I'm guessing that the source and destination in the dataflow are not connected..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply