About Sql25K and MDAC libraries

Dear all,
There is a problem which I am concerned about and is that kind of
compatibility own the old libraries, i.e, ado 2.5,2.6.,2.7sp1 within a Sql
Server 2005 framework.
We have a lot of old applications running with 2.6 and using RDO or even
DAO!!!
Does anyone have or is awared of any link related, any map or schema very
representative of all this stuff? Is very tricky try to imagine how manage
myself with such diversity of applications
Thanks in advance and regards,
Enric wrote on Wed, 22 Mar 2006 00:15:27 -0800:

> Dear all,
> There is a problem which I am concerned about and is that kind of
> compatibility own the old libraries, i.e, ado 2.5,2.6.,2.7sp1 within a Sql
> Server 2005 framework.
> We have a lot of old applications running with 2.6 and using RDO or even
> DAO!!!
> Does anyone have or is awared of any link related, any map or schema very
> representative of all this stuff? Is very tricky try to imagine how manage
> myself with such diversity of applications
> Thanks in advance and regards,
I have some VB apps using ADO 2.1 via ODBC that work fine with SQL Server
2005. ADO is an abstraction layer, not a driver library. SQL Server 2005
still supports the older connection methods.
Dan

About Sql25K and MDAC libraries

Dear all,
There is a problem which I am concerned about and is that kind of
compatibility own the old libraries, i.e, ado 2.5,2.6.,2.7sp1 within a Sql
Server 2005 framework.
We have a lot of old applications running with 2.6 and using RDO or even
DAO!!!
Does anyone have or is awared of any link related, any map or schema very
representative of all this stuff? Is very tricky try to imagine how manage
myself with such diversity of applications
Thanks in advance and regards,Enric wrote on Wed, 22 Mar 2006 00:15:27 -0800:
> Dear all,
> There is a problem which I am concerned about and is that kind of
> compatibility own the old libraries, i.e, ado 2.5,2.6.,2.7sp1 within a Sql
> Server 2005 framework.
> We have a lot of old applications running with 2.6 and using RDO or even
> DAO!!!
> Does anyone have or is awared of any link related, any map or schema very
> representative of all this stuff? Is very tricky try to imagine how manage
> myself with such diversity of applications
> Thanks in advance and regards,
I have some VB apps using ADO 2.1 via ODBC that work fine with SQL Server
2005. ADO is an abstraction layer, not a driver library. SQL Server 2005
still supports the older connection methods.
Dan

About Sql25K and MDAC libraries

Dear all,
There is a problem which I am concerned about and is that kind of
compatibility own the old libraries, i.e, ado 2.5,2.6.,2.7sp1 within a Sql
Server 2005 framework.
We have a lot of old applications running with 2.6 and using RDO or even
DAO!!!
Does anyone have or is awared of any link related, any map or schema very
representative of all this stuff? Is very tricky try to imagine how manage
myself with such diversity of applications
Thanks in advance and regards,Enric wrote on Wed, 22 Mar 2006 00:15:27 -0800:

> Dear all,
> There is a problem which I am concerned about and is that kind of
> compatibility own the old libraries, i.e, ado 2.5,2.6.,2.7sp1 within a Sql
> Server 2005 framework.
> We have a lot of old applications running with 2.6 and using RDO or even
> DAO!!!
> Does anyone have or is awared of any link related, any map or schema very
> representative of all this stuff? Is very tricky try to imagine how manage
> myself with such diversity of applications
> Thanks in advance and regards,
I have some VB apps using ADO 2.1 via ODBC that work fine with SQL Server
2005. ADO is an abstraction layer, not a driver library. SQL Server 2005
still supports the older connection methods.
Dan

About Connections and component mappings

1.After creating pacakages what i am concerned about is that when i move then to different locations do they work just the same as the had been.

2.About the mapping with in the components like lookups,and the variable with in conditional split or etc....do they get disturbed with any change in the location of the textfiles or anything of this kind of location change.

3.Is is adviceable transforming 5 to 6 text file with in one package in parallel

Please let me know

Thanks

1. They should work the same way. Just make sure the account executing the package has required permissions on all enviroments; but that is nothing to do with the package itself.

2. Same as above

3. That may be a matter of taste. I rather preffer to encapsulate an smaller set of functionality. A packag per every flat file may be; they could be run in parallel anyway.

|||Also, for #1, you can use package configurations to allow for easier maintenance of the file paths.|||

How can i use package configurations?For easier maintenance.How dod i do it.

Please let me know.

|||

Package configuration allows you to virtually overwrite any object property within a SSIS package. It comes very handy to deploy packages to different environments as you can override connection strings, paths; variable values; etc.

Here are a copule of links that talks about it:

http://msdn2.microsoft.com/en-us/library/ms141682.aspx

http://www.sqlis.com/?26

|||Keep in mind that a package is just an XML file that can always be opened in "notepad". Any concerns that you have could be resolved using ctrl F.