I'm sure there is a simple solution to this, however to save my banging my head against a brick wall: -
Within the "Execute SQL Task Editor" I have the following; -
Parameter Mapping Tab; -
Variable Name; - System::PackageName,
Directtion; - Input,
Data Type; - NVARCHAR,
Parameter Name; - 0,
Parameter Size; - 100
General Tab; -
SQLStatement; - INSERT INTO dbo.CustomSSISLog (System::PackageName) VALUES (?)
When I click on the "Parse Query" button I get the following error; - "
The query failed to parse. Parameter Information cannot be derived from SQL statements. Set parameter information before preparing command.
The table exists as follows; -
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[CustomSSISLog](
[CustomSSISLogKey] [int] IDENTITY(1,1) NOT NULL,
[PackageName] [nvarchar](100) NULL
) ON [PRIMARY]
Any help would be greatly appreciated.
If you have found any of my posts helpful then please vote them as helpful. Kieran Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds
View Complete Post