Can you try with the below one.

Go to Package Properties and then Go to Security Tab and then Change the Protection Level to "EncryptSensitiveWithUserKey"

Even, it was...

No Koen. I didn't open all the package at a time and i have only one configuration in it. Even for a small package also it takes time to open.

But...

Hi,

Thanks winash, tommyh for your quick solution. I have one more with me...

DECLARE @T VARCHAR(888)

SET @T = ''

DECLARE @TABLE TABLE (fldName1 VARCHAR(8), fldName2 VARCHAR(8))

INSERT INTO @TABLE

SELECT 'Test1','Name1' UNION ALL

SELECT 'Test1','Name2'...

Please check the below.

CREATE TABLE tblGetEmp (EmpName CHAR(8),Salary INT,Dept CHAR(1))

INSERT INTO tblGetEmp

SELECT 'aaa',10000,'a' UNION ALL

SELECT 'bbb',16662,'a' UNION ALL

SELECT 'rrr',73637,'a' UNION ALL

SELECT 'jhfdj',87683,'b' UNION ALL

SELECT 'jhk',7382,'b' UNION ALL

SELECT 'ewkjhk',98798,'b' UNION...

Thanks Phil. Let me try as you suggest.

Thanks Phil.

I am importing data from a flat file. In my flat file the text data is something like This is

sample text

This Flat file comes from a third party tool...

Even I really don't know how to check the identity of these. Also that is what my clarification is....

It is the plain text. No quotes in between. It is something like below...

This is

sample text.

Try something like below...

SET NOCOUNT ON

exec sp_name @UserDate = ?

and pass parameter in Parameters Tab (@UserDate = <Variable Name>)

Yes, i am sure package deployed it correctly on server. When deploying this we were getting this error. In our local we have tables for the disabled task. But in...

Specifically, i got errors from disabled task only. Non of the error from...

Yes, i am not using this disabled task table in non of the task in my ssis.

Red Color comes on Flat File Source or in OLEDB Destination? Send the error description along with.

If it is in Flat File Source, then check the followings.

1. Check the...

Phil Parkin (12/2/2010)

---

The title of this thread refers to columns, yet your posts refer to rows. That's an important difference - which do you mean?

For future reference, when you get...