Simply put: you join a table with a table valued function.

This article explains the concept and has some examples:

SQL Server APPLY Basics[/url]

I don't know if this is a one shot (if it is, you can simply convert to ASCII with the free tool Notepad++), but if it isn't, you can use...

jochr23 (7/25/2013)

---

The way it was configured as well in SQL 2008 R2.

The job actually does not overwrite any parameters within the ssis package, all parameters are being configured within the...

You can't use the new parameters in the package deployment model.

How did you configure the job?

Well, I'm glad someone is still awake 😉

Make the read as fast as possible (add indexes if possible, doesn't really matter if you read the entire table).

Disable indexes and constraint on the destination table if there are...

Maybe a permission issue.

Any errors?

You can first cleanse the data by replacing the multiple spaces by one.

This article has an excellent method on doing this efficiently:

REPLACE Multiple Spaces with One[/url]

How are you trying to execute the package in SQL Server 2012?

Is the package using the project deployment model or the package deployment model?

When you run the package, it has to load all of the data through the network into memory and then back into disk.

When you run it directly in SQL Server,...

Might be a permission issue. Which account do you use in the SQL agent job?

You did the whole SSIS, MDS, DQS thing from MSDN?...

sarwaanmca (7/24/2013)

---

select 5 & 17

What is the Output?

Ans is :1

1)how it will return 1 ?

...

You could also build an SSIS package to do this with the File System Task. (or with some .NET code)

You could also use SSIS with the Import Column transformation[/url]. Very easy to set-up and no need of writing code 😀