DSXchange

Hi,

I have a routine that has been secured, so no one can read the source code, associated with a particular project. Is there a way to share this routine with different projects without having to recreate the routine within each project I want to use it in?

Thanks for your help Ray :D and yes I will have to see if I can get a bit of help from someone.

I have created a routine to encrypt a personal identifier. I do not however want other developers to be able to access the code within the routine so they can not find out the algorithm used to encrypt the personal identifiers. Is there some way I can secure this routine so that it can be used in ot...

Try reformatting so that your statement reads

oconv(iconv(Input.Update_Date, "D-ymd[4,2,2]"), "D4-YMD[4,2,2]") : Oconv("00:00:00","MTS")

replacing the / with -.

I work with KWang and we have tried the profiler. It is not returning any errors. It just states "Batch Completed" but it totally misses the record of 31 characters we are trying to insert into a 36 varchar field.

Well, we finally figured it out with the help of the profiler. single quotes are required so that the code will be:
sch_yr = RIGHT('#Param_1#',4)

I thought we had tried everything including single and double quotes but evidently not.

Thanks again.

Okay, I spoke a little too soon. The Direct read does not seem to pass parameters back to the database. So, basically I still need help!

Okay, never mind. One of the guys figured it out over here. In the Output Action of the Output tab of the OLEDB stage - "Direct Read" must be selected. After that, everything runs fine.

Thanks everyone for your suggestions and into looking into this problem. :D

kcbland wrote:Okay, reverse that, are you comparing a numeric sch_yr to a string value, and that's where the problem lies? Just a guess.

I've tried using the following code to convert the string to an integer but I still get 0 rows returned.

sch_yr = CONVERT(SMALLINT,RIGHT(#PARAM_1#,4))

Hi Ken,

I tried using single quotes and double quotes and neither works. In fact the job fails as "OLE DB provider error: The command contained one or more errors."

RIGHT is a SQL Server function. The reason I want to do it in the OLEDB stage is to reduce the number of rows being read in, in this case about 600,000 versus 6.5 million.

Hi, I have a simple job to pull data into a sequential file from a SQL Server database using OLEDB. I want to restrict the records I am reading in by school year. We are passing in a 9 character school year ex. 2001/2002 but the database table uses a 4 digit school year ex. 2002. Therefore I need to...

Thanks for the info on KeyMgtKeyNextValue. Also, Thanks for the code on generating surrogate keys. It works great :D

I am trying to find a way to duplicate the identity function in SQL. I have found the KeyMgt transforms but I have been unable to find documentation on these transforms. I do know that the transform KeyMgtKeyNextValue will generate sequential numbers but how to use this transform exactly and what l...

I am trying to find a way to duplicate the identity function in SQL. I have found the KeyMgt transforms but I have been unable to find documentation on these transforms. I do know that the transform KeyMgtKeyNextValue will generate sequential numbers but how to use this transform exactly and what li...