question

artistlover avatar image
artistlover asked

Access Macro to SQL DTS or SSIs

I have this really nasty macro that I have to convert to dts or SSIS. If i could get it to dts I can work it to SSIS. But I've been given no time to complete this horrible task. Does anyone have any idea of a program or something i can do to create this to dts?
dts
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
You could run a DTS package as part of SSIS, but there's no automated tool that will convert DTS to SSIS. You'd be better investing the time into doing it in SSIS.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

artistlover avatar image
artistlover answered
My problem is that its an insane access macro with 100 plus parts.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.