This worked for me!! Thanks dudes!!!! :smooooth:

ps: M$ made a very good effort to discourage people from using DTS in MSSQL2005 -- you cannot create packages, when you add/delete a...

I cannot believe none of the people here had the same problem.

Please help me

Which column are you talking about? The source table or the destination?

Or the conversion error on the column?

I dont get why you want to keep the variable (@SuccessFlag) outside of the SQL string?

What you want to do is this:

@SuccessFlag=1

And it should be placed in a...

How does this one look?

CREATE PROCEDURE checknotexists

(

@TableName varchar(100),

@ColumnName varchar(20),

@Value int

)

AS

declare

@cSentence NVARCHAR(500),

@ParmDefinition NVARCHAR(500),

@ReturnCode int,

@RowCount int,

@NotExist bit

SET @NotExist = 0

set @ParmDefinition = N'@NotExist bit output'

set @cSentence = N'if not exists...

I mentioned MSQSQL function unthoughtfully.

EXEC is not allowed in functions.

So now how do we make the code ksullivan suggested reusable? I am sure people would like to call this procedure...

You cannot do it as they say.

Do something like this:

DECLARE @sql varchar(1000)

DECLARE @Table varchar(1000)

DECLARE @ID1 int

DECLARE @ID2 int

SET @Table = 'sysobjects'

SET @ID1 = 1

SET @ID2 = 5

CREATE TABLE #TMP (ID...

There might be a very good reason to create DST packages in SSIS 2005.

Imagine the following scenario:

A company has 500 DTS packages working in MSSQL2000, interconnected between each other,...