Do you have the right permission on the database where the stored procedure exists, which you are trying to execute?

VG

You can try using data conversion transformation in between to the data type you wanted, in your case DT-Date.

-VG

SSIS is developed in visual studio environment, so you need to open the solution (.sln)and then open the package(.dtsx). Then See the sql syntex if any.

Here is the link for...

Yes...I found that link too....It is really good...and I got it working my SSIS packages...

Thanks for your feedback...

Have a nice week-end

VG

Thanks again jonh!!

I downloaded it and let me explore with it....

VG

Thank for the reponse john!!!

Is this free to download ?? ...I don't see download link in here http://www.sqlis.com/23.aspx

Thanks,

VG

Where did you all installed File Watcher Task From ? IS this is a custom task?

Is this similar to WMI task in SSIS ?

Thanks,

VG

I don't know, you tried the similar way..I suggest, use Conversion task in between and use dt-str data type there and use this derived column to map to destination column.

-VG

I think error with dynamic sql

ALTER PROCEDURE [dbo].[sp_EdicionImpresaDetalles]

@iEp_Id int=0

,@iEp_E_Id int OUTPUT

,@iEp_R_Id int OUTPUT

,@iEp_Seccion int OUTPUT

,@sEp_Nombre NVARCHAR(100) OUTPUT

AS

BEGIN

--...

You must have checked this, make sure you selected, Destination Copy options - CopyAllDefaults to TRUE.

-VG

Do you have SP2 fro sql server 2005? That is the latest..

-VG

You have to use dynamic sqk for this

set description = '16"X14''' + 'PR F/G bead'

-VG

This is a very common problem is SSIS..So, what you are trying do if you can explain, there will be a better solution....

I am guessing, defining your variables scope ...

In Flatfile connection manager editor, advanced options like output column width, change it to bigger number, can be given same as your database table column width for this column...

-V

You need to add After insert, update if need for both insert and update...

CREATE TRIGGER dbo.trptAppointmentsINSERT

ON dbo.ptAppointments

AFTER INSERT, UPDATE

AS

BEGIN

...