Home Forums Data Warehousing Data Transformation Services (DTS) Help with Sql Query parameters please (copying Access data to Sql Server) RE: Help with Sql Query parameters please (copying Access data to Sql Server)

  • June 17, 2010 at 10:37 pm

    #1181908

    Hi Burak30,

    you cant do that in the way as you are trying..

    I guess you are writing the SQL query in Execute SQL task, this task works on Single connection, where as your query has two connections, source (Access) and destination(SQL Server, i.e ?). use DF task , you will get it.

    Regards

    RB