December 8, 2008 at 3:49 pm
What I am trying to accomplish is create a DLL that can be called used from any program which will take two parameters a view name and a file name and export the given view to the text file as a CSV. I had done this a few years ago in SQL Server 2000 using DTS but I am having a really hard time doing this in SQL Server 2005 SSIS in C#.
I have checked out several packages and am playing around with some sample code but I have not gotten anywhere so far.
The approach that I have seen so far is to use IDTSComponentMetaData90 and IDTSDesignComponent90 to define the components assign connection managers to them and connect them using an IDTSPath90 but I have not been able to successfully produce anything that I can use. If anyone can help me out with a sample that would be really wonderful
Thanks in advance. After 4 days of struggling I finally decided to ask for some help.
December 8, 2008 at 8:51 pm
Are you wanting you create a DLL or an SSIS package? If it's the former, you should be able to do this with just a few lines of code in your DLL class. If it's the latter, you could use expressions to identify the table name and output file name.
If you can provide some more information about what you're trying to do, it'll be easier to help you with the specifics.
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
December 9, 2008 at 1:14 pm
I am trying to create a DLL. Could you please provide me with a sample for this if its a DLL?
I dont need to create an SSIS package All I need to is have a DLL that exports a view to a flat file but not like writing out a linear text file. I need an export a linear text file would take an enormous amount of time for the number of rows in the view.
Thanks much
December 10, 2008 at 12:42 pm
Any help on this ? I am really sort of stranded.
Thanks
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply