hey...

i was also facing same problem for same task....

so finally i tried this query in execute task of ssis and it works properly.

INSERT table2( col1, col2, col3 )

SELECT...

Hi,

i have tried this but i am getting following error:

Cannot bulk load because the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcnf.xml" could not be opened. Operating system error code 3(The system cannot...

Really thanks for ur help..................

thanks for your reply....But i want it in SSIs because i want to schedule it everyday through SSIS.

can you give me link for online practice tutorial for SSIS.