[font="Verdana"]From your post, what I understood is you need to copy some files from FTP location to local location first and then FTP the same files to FTP again. You...

[font="Verdana"]

Gianluca Sartori (9/23/2011)

---

If you fall...

try this ...

Begin Try

Begin Tran

Insert Into TableName Values (99, 'ZZZ');

Update TableName

SetColName = 'XXX'

Where ColName = 99;

Commit Tran

End Try

Begin Catch

If @@Error <> 0

Begin

RollBack Tran

End

End Catch

[font="Verdana"]Thank you all!!![/font]

[font="Verdana"]Brandie, currently I have just declared the SQL variables, not SSIS Package variables. And the variables I have decalred in the first 'Execute SQL Task', wanted to use in other...

[font="Verdana"]

Below is the flow of the SSIS package.

1 'Execute SQL Task'

...

Declare@UserTypeIDBigInt

Select@UserTypeID = UserTypeID From dbo.User(NoLock) Where UserType = 'Customer'

Insert Into <temp Table>

Select<Columns>

From<tables>

WhereUserTypeID = @UserTypeID

...

2. 'Another Execute SQL Task'

Select<Columns>

From<anothertables>

Where... And...

[font="Verdana"]Use the Advanced Editor to explore each column type so that you know where such conversions occur.

-- Mahesh[/font]

[font="Verdana"]

Hopes, below code might help you out. However you need to look into the logic first, before executing it. And hopes you will make corrections in logic, if any.

DECLARE @Proc_Name...

vk-kirov (12/8/2010)

---

Good question.

But this is not an explanation at all:

I suggest the following explanation.

The SELECT...

[font="Verdana"]

Check by enabling the Use 32 bit runtime option in Job Step properties > Steps > General > Execution options [if Type: SSIS package]

Thanks,

Mahesh[/font]

[font="Verdana"] thank you very much Larry.

-- Mahesh[/font]

[font="Verdana"]

No, we have clustered index on ID column. recently we have added one more column, called...

[font="Verdana"] Thanks for your updation.

However we already do have Clustered Index on our table. So can we add partition with Alter Statement?

Thanks again,

Mahesh[/font]

[font="Verdana"] Thanks for you updation.

However we already do have Clustered Index on our table. So can we add partition with Alter Statement?

Thanks again,

Mahesh[/font]

[font="Verdana"]your t-sql code is not a dynamic sql. in @SystemRule variable you are ftching column's value and in the next line you are tryingto execute it. It wont work this...