problem in calling dll file using scripttask in ssis

Question

Post reply

problem in calling dll file using scripttask in ssis

guru12

Ten Centuries

Points: 1068
More actions
August 2, 2010 at 7:02 am

#144388

Hi Everyone...
My scenario is ,i have a DLL file and i want to call the Dll file to SSIS using scriptask,So i am zero knowledge preson on .net,so can any one provide the script to call dll file and execute.It's very urgent can anyone help me,Waiting for ur reply..
Regards..
guru12

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

This article on SSC should be useful to you.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Adiga One Orange Chip Points: 27284 More actions · Answer 2

This article does it with screen shots.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

guru12 Ten Centuries Points: 1068 More actions · Answer 3

Hi Everyone.....

Any one Please give the reply ,its very urgent..

Regards..
guru12

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

Please respond to Pradeep Adiga's posts - why is that not what you want?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

guru12 Ten Centuries Points: 1068 More actions · Answer 5

Hi Pradeep Adiga..

I din't find any related info in that link what you posted,please provide the exact link where can i get solution.Waiting for your replies..

Regards..
guru12

Adiga One Orange Chip Points: 27284 More actions · Answer 6

Both the links that I provided have "How to" do it information on Importing a custom DLL. If they are not useful then I might have misread the requirement.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

guru12 Ten Centuries Points: 1068 More actions · Answer 7

Hi Pradeep..

i am giving my requirement ,please provide answer,its very urgent.My requirement is I have a Dll file which contains 8 variables,example like sourcedabase,destinationdatabase,sourceservername,destinationservername userid and password.so for this i have created package variables in SSIS and assing them in script task like the following and given value to that variable.

dc.SourceDatabaseName = this.Dts.Variables["sourcedatabase"].Value.ToString();

dc.SourceServerName = this.Dts.Variables["sourceservername"].Value.ToString();

dc.SourcePassword = this.Dts.Variables["sourcepassword"].Value.ToString();

dc.SourceUserName = this.Dts.Variables["sourceusername"].Value.ToString();

dc.TargetDatabaseName = this.Dts.Variables["ddatabasename"].Value.ToString();

dc.TargetPassword = this.Dts.Variables["dpassword"].Value.ToString();

dc.TargetServerName = this.Dts.Variables["dservername"].Value.ToString();

dc.TargetUserName = this.Dts.Variables["dusername"].Value.ToString();

dc.OutputFileName = this.Dts.Variables["filepath"].Value.ToString();

My requirement is to compare source and destination databases,my dll file has the code to compare,so when i run my ssis package it is not comparing any databases and it is not throwing any error also,can you please suggest any help for this,if you din't understand my requirement i will write again ,i need some help on this.waiting for your reply...

Regards..
guru12