Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

You can't use the object variable in a conditional split, as the component expects scalar values.

In the For Each Loop, you need to map the current value...

You can't use the object variable in a conditional split, as the component expects scalar values.

In the For Each Loop, you need to map the current value of the object...

Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

What do you mean with "now i need to pass four values to the table which needs to loop the package."

Do you need to insert data into...

The OLE DB adaptors shouldn't be that slow.

Did they read slow or write slow? You did use the fast load option in the OLE DB Destination, I hope.

Check out the...

DECLARE @where NVARCHAR(MAX);

DECLARE @SQLStr NVARCHAR(MAX);

SET @where = 'where id <45;'

SET @SQLStr = '

DECLARE @mande bigint;

set @mande=0;

update balance

set @mande=bal= @mande+(bad-bas)

,tash=(case when bal>0 then ''BD''

when bal<0 then ''BS''

when bal=0 then ''BI''

end )...

Why don't you run the job again to try and find out?

What do you mean with "now i need to pass four values to the table which needs to loop the package."

Do you need to insert data into the table?

Martin Schoombee (2/2/2012)

---

imani_technology (2/2/2012)

---

I have an Excel 2010 spreadsheet that I need to import. That spreadsheet has a column. In some cells in that column, the values are...

Revenant (2/2/2012)

---

That is a prefectly valid question.

Yes, connection strings in the database work only for run time.

If you need to work with connections during design time, you will be probably...

This article is a good starting point:

SSIS Design Pattern - Incremental Loads

Also take a look at the TSQL Merge statement if you are using SQL 2008 and up.

sudhirnune (2/2/2012)

---

Finnally Was able to Fix the Issue.

Reason: The Account (Domain Account) used for Creating the Proxy, was not having Admin right.

Because of which if the Execel file Size is...

That one is even more irrelevant.

Typing in some keywords in Google and posting every result here on the forum isn't helping anybody.

Please do some...

If you want someone to do the work for you, hire a consultant.

Give a man a fish and you feed...

STLineFromText <> STLinefromtext

Got it wrong because I missed that query 4 didn't had capital letters in the middle of the word. Ah well, interesting question.