morfasie


Hi,


I have created a SSIS dtsx package file on my file system that I want to manipulate in .NET

The package gets an access DB file and the a Preparation SQL Task creates the necessary sql statements for the data flow task. The data flow maps the tables from the source to the destination and then if you execute the package, it copies the Access DB into SQL Server.

My problem is, I want to manipulate this package in code, so that I can change the path to the source Access DB and then re execute the Preparation SQL Task so it recreates the new SQL statements, and then I want to update the data flow so that I it uses the new SQL and creates the necessary tables.


How is this possible in .NET

I have looked everywhere and have found some topics but with no luck.

Can anybody please help me



Re: SSIS Access import to SQL Server 2005

Philippe


I do not think you really need to code the package on the fly to do that.

You can use expressions, variables and sp's or jobs to execute the package with the appropriate values, if a code runs the sp or the job or the package, it is just fine like this, even if it is a CLR procedure.

Look a the ssis package as a class with encapsulated methods and properties. Build it like that.

Philippe






Re: SSIS Access import to SQL Server 2005

morfasie

Thanks man,


could you maybe give me some clues please, or where can I find the ssis package class



Thanks





Re: SSIS Access import to SQL Server 2005

Philippe

This was not a specific advice, just an advice as of you could think about a package.

I do not know if a "Class" can exist for it, may be, but in the meantime just look at it like if was one and you may find the way.

Does anyone have experience with referencing a package as a class in a VS project can it be done

Given the power of dotnet and SQL I would think it can be done. I am not good with this stuff Just trying to go up there.

Otherwhise, my idea was just refering at using the package the dum way with only SQL at your fingertips but with a class state of mind.

Philippe