Post reply

Problem with execute SQL Task

  • December 9, 2009 at 7:10 am

    #218622

    Im trying to execute an SQL task from SSIS (2005). Its a simple script that truncates a few tables then inserts a row in a table that contains the current date

    Truncate Table Feeder.dbo.tblCompany

    Truncate Table Feeder.dbo.tblCompanyLocation

    Truncate Table Feeder.dbo.tblLocation

    Truncate Table Feeder.dbo.tblFinancialFeed

    Truncate Table Feeder.dbo.tblAdverseCreditFeed

    Truncate Table Feeder.dbo.tblAdverseCreditDeletionsFeed

    Truncate Table Feeder.dbo.tblHistoricDissolvedFeed

    Insert INTO Feeder.dbo.tblSequenceNumber(DateCreated) values(GetDate())

    Ive setup a connection to my local machine where i have a test database setup. My login (sbs\whm on my pc) is mapped as dbo in the local instance of SQL server

    The SQL task is mapped to the connection for my local db instance, Ive tested it, and it works ok in the wizard. I have logging enabled on every event of the execute SQL task. (Its checked in the 'configure ssis logs' screen)

    When I run the package, the task initially turns yellow, then red. The script isnt executed (no row has been added to the specified table)

    Checking the log text file reveals 2 entries only

    OnPreValidate,W167,sbs\whm,Step01a Clear out tables in Feeder,{CF0D9B3B-E5B0-4198-A723-E8281464FBB3},{65348A8B-A49E-45D8-9559-3BF273F82344},09/12/2009 13:52:21,09/12/2009 13:52:21,0,0x,(null)

    OnPostValidate,W167,sbs\wm,Step01a Clear out tables in Feeder,{CF0D9B3B-E5B0-4198-A723-E8281464FBB3},{65348A8B-A49E-45D8-9559-3BF273F82344},09/12/2009 13:52:21,09/12/2009 13:52:21,0,0x,(null)

    If the task failed, where are the error messages ? I have no idea why its failing, I have permissions to execute the sql statements (im connecting as dbo). The lack of any messages is making it impossible for me to work out why this is failing.

    Can anyone help ?

  • December 9, 2009 at 7:15 am

    #1089826

    What does the progress tab show?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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