In this link he has changed the result set to 0 but in my case i am bringing the data and assigning to some variable and i was using the...

when i run the query i get only 1 result set .and i am still not able to figure out where i am going wrong .so we can use...

Hi !

I run the below query with SSIS on sybase DBMS but i was getting the error message stating that "No disconnected record set is available for the specified SQL...

Hi Sam!

I have a quick question to this topic...If i need to loop the query on different servers, is it possible? as we are keeping the retain same connection to...

Hi I even tried converting to DT_WSTR, but still its giving out error .

Hi !

I am also having the same issue any progress on this issue ?

So how would my script be ????

Thanks in advance

Hi !

I won't be able to use select into as i will be running the multiple query's to a multiple servers(around 400) by looping to each server.

Hi !

Yes all the queries are select and they get different data with different structure of columns,So in the run time when the queries are run against the server ,I...

Hi !

This issue was resolved once i installed 64 bit Oracle client

Hi !

I am New to SSIS Development can you please provide me the sample code for 2008 version ? as i was getting the error messages related to override with...

I have list of user names and passwords servers and databases in a table and is it possible to make a dynamic oracle connections with out any TNSnames.org file...

After Creating the link server ,how can we connect to different Oracle databases from SSIS packages .?

Thanks in advance 🙂

Hi !

Can some one guide me how to implement power shell scripts using the SSIS development ,as i need to run on all my present servers(around 300) to get IP...

In Order to install again go to run and type REGEDIT and there under softwares->Microsoft-->SQL Server -->delete this SQL Server folder and try to install the SQL Server Again