Hi

-----------------------------------

CREATE PROC test

@year int, @code int, @batch int

AS

BEGIN

IF (@code IS NULL OR @code = '') AND (@batch IS NULL OR @batch = '')

BEGIN

SELECT columns

FROM...

Thanks Jared. its working now.

Another issue is that how can i pass optional parameter while running the package through SQL Server Agent job.

Regards

SqlStud

is there any other solutions for this issue

Regards

SqlStud

Thanks Howard.

So, we need permissions for all the packages to execute it from SQL server job agent

Regards

SqlStud

Thanks to all

Hi

As already said

It is Fixed length Format.

There are no delimiters in the file so when one field ends, the other starts without any tabs, comma(s), or spaces between them. Whitespace...

Hi,

Is it possible or need to follow the other way ie creating SP etc

Regards

Sivakkolundu

Can anyone please reply on this.?

I need to complete the task today

Regards

SqlStud

It is Fixed length Format.

There are no delimiters in the file so when one field ends, the other starts without any tabs, comma(s), or spaces between them. Whitespace fills...

Great Jared and Thanks.

I have used the below query. Is it Correct?

YEAR = @MLR_YR

AND (@CODE IS NULL OR CODE='' OR CODE=@CODE)

AND (@BATCH IS NULL OR @BATCH ='' OR BATCH= @BATCH)

Regards

SqlStud

Thanks Stewart

🙂

Not yet decided. but it will be at regular intervals

Ok..

But the filename should append with numbers from 0-9

ie

Filename1.txt

Filename2.txt etc

Regards

SqlStud

I have used the output file format in expression properties

"\\"+ "\\Sample\\Shares\\Medical\\"+@V_Path+"\\MDM\\MDM_"+ (DT_WSTR,4)YEAR(GETDATE()) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()),2) + RIGHT("0" + (DT_WSTR,2)DAY(GETDATE()),2)+".csv"

How will i use Random number? Please suggest

Regards

SqlStud

No Stewart.

Only datepart given in the filename