changing charater from sql file through SSIS

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)

changing charater from sql file through SSIS

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-05-13 : 08:47:46

I want to create SSIS for purpose

I have .sql file that i need to pass sql file having delete functionality
delete from Test where ID = #ID

I need to replace # by @ and my sql will look like

delete from Test where ID = @ID

any help

T.I.A

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources