Actually i am using merge and i designed the whole package. I just want to add this condition.

Can i still use your suggestion if i continue to use merge...

sql server 2008

oracle 10g express Edition

Hi

This is in regard to my last post. I manages to write the expression but i got the new error now like:

[Execute SQL Task] Error: Executing the query "Insert into...

Isnt the default port for ftp is 21. Thats what comes up when we start to configure the ftp task in ssis.

I am new to using FTP in ssis.

Can you please explain what you meant when you say:

telnet your_ft_server 22

?

Thanks

Hi

I am creating a header in flat file which is a destination as suggested by you in your post. i want to pass the record count in the header.

I am...

I have made a typing mistake in the last post. Ignore it please.

Actually i am loading the data into oracle and as far i know ssis does not have the...

Hi

Thanks for the reply.

I am not data into oracle. Will the expression that you suggested will work there too.

Thanks

Hi

I was reading your posting regarding creating headers and footer in a flat file. It helps me a lot.

I am concern about the footer that i want to...