Post reply

Dts Package query not working

  • January 12, 2005 at 12:58 pm

    #66860

    I have a sql query which works perfectly in sql query analyzer and brings 6 records but doesnot bring any records in the transform data task preview..stumped..same login, same databases

    SELECT     b.*, b.strAuthtype AS 'authType', b.strstatus AS 'StatusType'

    FROM         datavault..tblAuthorization_test b LEFT JOIN

                          ea_test..tblAuthorization A ON b.lngAuth = a.lngAuth

    WHERE     a.lngAuth IS NULL

  • January 13, 2005 at 8:15 am

    #537298

    Security permissions maybe? Check how your DTS connection is configured. It may not have permissions to read one or both of the tables.

    Shalom!,

    Michael Lee

  • January 13, 2005 at 10:02 am

    #537323

    Once you fix that issue, you might also consider dropping the duplicate mapping of the b fields.  Also bad form to use * in your source sql.  Guess what happens when someone adds a field to the source table?

    [font="Courier New"]ZenDada[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply