Hi Rock,

Thanks for the Example and Data, It works for me it the Source is SQL DB, My Source here is Excel File.

From which I retrive the data.

I will Test...

Thanks for the Details.

I hope I made my Examples more Complex, than needed to get help.

The Requiremnet is Simple, when the Input Data Columns have the Following Charecters ( '...

Sorry for the Wrong Eample above, below is what is needed

FINDSTRING ("STRING&32","&") != 0 Works

FINDSTRING ("STRING\32","\") != 0 Not Working Working (Its shows Syntax Error)

FINDSTRING ("STRING\32","\\") != 0 Not...

please needed help....!

Actual Issue I am Facing is the Trim Function whcih is not removing the Spaces from the Data.

The Data Source is frm Excel Sheet.

Please need help to solve it... 🙁

There is no Error, Data Flows with out any issue.

Example: " SUDHIR" or "SUDHIR " or " SUDHIR "

when this is the Source data in Excel, comes in to the...

Solution is that,

1. Open the Data Flow

2. Click / Select the Data / Source Component of Oracle DB

3. Now Right click and Select Advanced.

4. In the Advanced window go to...

Hi Dev,

We have Already the Data Conversion setup in the Data Flow.

The Package work Fine when Executing it in the INtegration Services by "Run-Packge".

But Fails in Job...!

Thanks for the reply, I will try to do as you said.

Thanks Anthony,

But it can retrieve the Data which is from Previous Run Too....

So I am looking for some way where I can confirm that the Exact Job ID is retrieved...

Thanks elifestyle

thanks a lot for the information "Lowell".

Its solved my issue.

When checked the Store Procedure, we were not able execute the OPENROWSET which get the network user details. which can not...

I tried the same query on SQL Server 2008

But not working, it says in correct syntax near rowset

SELECT * FROM OpenRowset(NetGroupGetMembers, 'Domain\user')

Please need help to tell me how this...

I tried the same query on SQL Server 2008

But not working, it says in correct syntax near rowset

SELECT * FROM OpenRowset(NetGroupGetMembers, 'Domain\user')

Thanks for the Reply,

Wanted to check is there any way to check to which all proxies a system_user has access to

any function / query which can show me that info.