Thank you guys for your help... both answers helped a lot!!.. after fixing the code with your both suggestions the script run but got a new error:

Server: Msg 7399, Level...

Hey... thanks for the help... it seemd to solve the problem.. but now I got another error:

"Server: Msg 7415, Level 16, State 1, Line 1

Ad hoc access to OLE DB...

Yes,

but I got error on local testing before adding SET ANSI_NULLS ON and SET ANSI_WARNINGS ON in the script. After I added both settings then the error was gone on...