Thanks a lot guys for your quick reply..

Cold Coffee,

Is there any other work around instead of using of cross apply?

Please share your thoughts? Just curious to know..

Would you please provide us some test data?

It will be a great help to do work around.

Sudha

Here is the good article by Matt Masson.

Please go through this article for given below link:

http://blogs.msdn.com/b/mattm/archive/2011/11/17/what-s-new-in-ssis-for-sql-server-2012-rc0.aspx

You gave me the solution,as i need the 1st Select Statement.

I Thank you again.

Thanks Lynn

@koen,

I am using BIDS.

and also i had set the column mapping in the OLEDB Destination.

I am looking warning sign that i had pasted below.

Warning:Validation warning. Data Flow Task: {9E207FB6-BD00-4642-BE4C-D9639BFFE7EE}: Truncation...

Thanks

It works , i had used the Convert function and then divide by 100.

Hi Rozema,

I most likely to use your scenario as you told me that.

You need to create the staging table and develop the one store procedure.

Then load the data into the...

Hi Sturner,

I don't have permission to use the Bulk Load Statement.

Is there any other way to load the data in to staging table?

Please, let me know.

Thanks,

Jkp2311

Because of security reason, i can't upload

the .dtsx file here.

If you don't mind ,would you suggest some workaround to resolve this type error.

Let me do my self..

Thanks for your reply

yes , i am connecting from SSMS.

And i removes the instance name.

Please read the below error.

TITLE: Connect to Server

------------------------------

Cannot connect to TestServerName

------------------------------

ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For...

When i try to connect the Intergration Service engine

on Testing Server.

I get error.Please read below..

TITLE: Connect to Server

------------------------------

Cannot connect to "TesServerName\inst1".

------------------------------

ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

------------------------------

Invalid server...

I had set the package configuration in my SSIS Package.

And i have not access for SQL Server Agent.

Without SQL Server Agent, can i run the package in QA Environment...?

PLease let...

Do i need the Microsoft office 2007 in my machine...?

Once package is developed in DEV environment.Then it is moved to QA and Prod

environment.Because of this reason , i can't set the password on SSIS package.

IS there any way...