Skip to main content
C
cfnew
Known Participant
May 7, 2009
Question

need help to make dts package to coldfusion file with stored proc

  • May 7, 2009
  • 1 reply
  • 991 views

Hi i am new to coldfusion and i need some help regarding how to change dts package in to coldfusion and i want to know how to make the dts package fiole in to stored procedure .

Can anyone help me how to mhake it in to stored procedure or otherwise help me to make this dts package in to coldfusion file please help meee...

I am attaching the file that contains the DTS package USED before.

Thanks,

Kiran

This topic has been closed for replies.

1 reply

ilssac
ilssac
Inspiring
May 7, 2009

Just curious why you would do this...

Most people would move the other way... Take a CFML code that is doing heavy database lifting like this and move it into a stored procedure or DTS package, not the other way around.

But if you are set on converting this... mostly you just need to wrap the SQL statements in <cfquery...> blocks...

<cfquery...>
    SELECT DISTINCT
    INTO #di_audit_corp_upc_ldr_tbl
    FROM [dbo].[di_audit_corp_upc_ldr_tbl]
</cfquery>

<cfquery...>
    DROP TABLE [dbo].[di_audit_corp_upc_ldr_tbl]
</cfquery>

The cursor section is a bit more complicated, that would become a basic <cfquery...> using the Select SQL... and then you would loop over the returned record set with either <cfoutput query=""...> or <cfloop query=""...> doing the iterative logic...

But really WHY?

C
cfnewAuthor
Known Participant
May 8, 2009

Hi Lan thanks for ur reply appreciate that and would u please tell me how to convert this in to CFML file ,because i dont know how to convert this in to cfml ,would u plz help me in this.

Thanks,

Kiran

ilssac
ilssac
Inspiring
May 8, 2009

I beleive I did suggest how you convert this....

As to converting it for you... Sorry I do not have the time to do so at this moment...

The usuall rate for contractors to write code for you is $25 to $100 per hour U.S.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices