i have an mdb with lot of tables in it. But now since the old mdb is not so flexible the way user wanted, the requirement is creating a new mdb with different tables some of them matches the way the old table but some it is combination of fields from more than table in old mdb.
For example old.mdb table name: associate Fields : first name, last name. personid
table name: Network Fields : network id, person id
...
bhu
Last Activity: Dec 5 '07, 04:15 AM
Joined: Oct 4 '07
Location:
-
Can you tell me how to register dll and what are the dll's need to be registerd -
i got a compile error at the beginning of the code:
Public goPackageOld As New DTS.Package
Public goPackage As DTS.Package2
User defined type not defined.
If i do the reference to dtspkg.dll it works with no error, but the problem i need to copy the adp and ade to the server and i had the dll copied to a folder along with the adp and ade.Leave a comment:
-
User Defined Error in DTS VBA module
User Defined Error in DTS VBA module
--------------------------------------------------------------------------------
i saved DTS package to VB script file and made it as a module and included in my adp.
When i compile i get a User defined error, i have referenced to required DTS dll.
Please let me know what is the error and how to solve it -
User Defined Error in DTS VBA module
i saved DTS package to VB script file and made it as a module and included in my adp.
When i compile i get a User defined error, i have referenced to required DTS dll.
Please let me know what is the error and how to solve it -
SSIS and VB
I converted sql 2000 package to ssis. I had flat file to table and i had some activex script for formatting of columns in the dts. hence when i migrated to sql 2005 ssis those steps are converted to execute sql 2000 package task and when i try to execute the package from vba all other steps execute except these steps.
Can anybody can tell how to make this step run from VB or how to run the dtexec from VB.
thanks
... -
SSIS and visual basic
I converted sql 2000 package to ssis. I had flat file to table and i had some activex script for formatting of columns in the dts. hence when i migrated to sql 2005 ssis those steps are converted to execute sql 2000 package task and when i try to execute the package from vba all other steps execute except these steps.
Can anybody can tell how to make this step run from VB or how to run the dtexec from VB.
thanks
...
No activity results to display
Leave a comment: