No,we didnot schedule it 2 times.

how should i check in SQL Agent.

Hi ,

I tried the process i mentioned above and i got this error:

Executed as user: sqlserver. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright...

well i donot have any idea to do this .

I have one more question, the destination of this file is a FTP like i mentioned how should i proceed by...

Thanks for the reply mike.

This is what i am trying to do:

I have a stored procedure which will send data to oracle using linked server .since the procedure is...

No ,using SSIS i am only sending FTP not the data directly to oracle tables.

Could you explain me how to do that?i could try that too

Yes ,you are right i found it .thank you very much.

Could anyone also please tell me how to use variable like i asked in my previous post..

I have tried using execute task in SSIS and succeeded till half .

I did this :

i have dragged execute task and in the sql statement i wrote this :

Declare

@ID...

yes ,you are right...

Thanks for the reply.

Hi skcadavre ,

Thank you very much for all the replies.

I have tried everything which didn't work and i know the reason the problem is not with the syntax,the data in...

Thanks for your help skcadavre .

This is what i did :

Derived REQUEST_DATE<add as new column>(((SUBSTRING(REQUEST_DATE,5,4) + "-" + SUBSTRING(REQUEST_DATE,3,2) + "-" + SUBSTRING(REQUEST_DATE,1,2)) == "--") ? "" : (SUBSTRING(REQUEST_DATE,5,4) +...

where should i specify input column ,i have replaced date with my input column and i got error.

can you please give me full syntax.

I have created a staging table in the same database where i have the destination table too,and loaded all the rows into the staging table successfully,now i am going to...

i have attached the source file :

I found this to convert string to a date datatype while looking for answer to above error:

Dts.Variables("someDateTimeVariable").Value = GetDateFromString(Dts.Variables("someStringVariable").Value.ToString)

but i don't know how to use it or declare variables for...