Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Parameter Mapping

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2009-04-30 : 10:47:44
I'm using the sql task something like this.

IF 'APPEND' = ? -- (set to 0 in the parameter mapping)
BEGIN
INSERT INTO TEST VALUES ('TEST1')
END

Its throwing me an error. The same works fine if i create a stored procedure with input parameter like, exec proc ?, Is there a way to run the TSQL statements with out creating the SP.
   

- Advertisement -