Execute T-SQL statement task with Execute Package Utility

Question

Post reply

Execute T-SQL statement task with Execute Package Utility

MR_Nille

Grasshopper

Points: 10
More actions
June 23, 2010 at 7:20 am

#387204

Hi,
When I open my .dtsx file to run it fails. My only error message is "Task Execute T-SQL Statement Task failed" and nothing more.
When I run the package in SQL Server Business Intelligence Development Studio it work perfect.
Anybody have a suggestion what the problem could be? I run a delete table and create table in the task as below.
drop table renault
CREATE TABLE [RENAULT] (
[KOD] NVARCHAR(255),
[KOD2] NVARCHAR(255),
[MODELL] NVARCHAR(255),
[KAROSSTYP] NVARCHAR(255),
[MOTOR] NVARCHAR(255),
[HK] DOUBLE PRECISION,
[KOD3] NVARCHAR(255),
[VÄXELLÅDA] NVARCHAR(255),
[KOD4] NVARCHAR(255),
[UTRUSTNINGSNIVÅ] NVARCHAR(255),
[FAKTURAPRIS] MONEY,
[ÅFPÅLÄGG] MONEY,
[ÅFMARGINAL] DOUBLE PRECISION,
[REKPRIS] MONEY,
[F15] NVARCHAR(255)
)

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

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

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Where are you doing "When I open my .dtsx file to run it fails."

Also does your connection to the database use a password or does it use trusted security?

CEWII

MR_Nille Grasshopper Points: 10 More actions · Answer 2

Doubbleclick on it from the windows explorer. Also the same error if I put it on the Integration Server and run the dtsx. It only works in the Visual Studio.

Same error if I have the database connection with trusted or with password.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Sounds like a permissions problem. Run a trace on the SQL server and see if it is even getting logged in and starting the process.

CEWII