ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I am trying to get a SQL script to execute from a package, the SQL will
run from MS SQL Query Analyser, and I can execute other SQL (both before and after) during a Table Import process, but when trying to execute a SQL script from the package it doesn't seem to execute, it doesn't
fail, it just doesn't do what it is suppose to.

Any ideas ?

Have you specified sql statements seprator?

It should be like
exec proc1
go
exec proc2
go

Mike

No,

I was just trying to run some SQL as a step of a package.

My SQL looks like this :

UPDATE S_CONTACT_X
SET X_ATTRIB_105 = NULL, X_ATTRIB_106 = NULL
WHERE X_ATTRIB_105 = 'XXX' AND X_ATTRIB_106 = CONVERT(DATETIME,
'2099-01-01 00:00:00', 102)

Do I have to create a stored procedure and execute that? Or do I just
have to write the sql in script?

ali