SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Access tasks in Data Flow Task dynamically
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

revathiganesh55
Starting Member

India
2 Posts

Posted - 11/16/2012 :  00:44:59  Show Profile  Reply with Quote
Hi friends,

I have a package where the number of columns in DB tables could be changed. I want to change the meta data of data flow task dynamically. Also the mapping details will be in a seperate table as the source and destination column names need not be same.
Could anyone please help me on the same.

Thanks and Regards,
Reva

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 11/16/2012 :  23:01:56  Show Profile  Reply with Quote
you cant do it unless you create the data flow objects on the fly programatically in a script task. you need to call library functions to refresh metadata each time inside script task.
I cant understand why your table structures are so varying though!

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

revathiganesh55
Starting Member

India
2 Posts

Posted - 11/18/2012 :  23:56:00  Show Profile  Reply with Quote
Thanks for your reply!
New columns can be added and deleted as per the business requirement.

Could you plz tell me if I can modify the existing package and just change the meta data.

Reva
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 11/19/2012 :  02:02:31  Show Profile  Reply with Quote
you can modify package and edit metadata to add or remove columns. Whenever table structure changes, open package in BIDS/SSDT and click on source task and it should fix errors automatically and you just need to add the new columns.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000