No doubt Gail will fix your problem more elegantly, but here is one idea (untested). In your script:

1) Define a temp table with the same structure as TableA.

2) Call the...

Using a Script Task (for Step 2) you mean? If Delay Validation is set to False it would error out, but would not be able to provide a nice message...

Lempster (7/3/2014)

---

If the users can upload any Excel file then I don't see how you can have a static Excel Source.

It is possible to create a dynamic Excel destination...

SSIS depends on static...

gajayku (7/2/2014)

---

Hi

Thanks for quick response. Let assume that I have schema of both source and destination in the following formats.

In excel File, I have columns (Id, Name, Salary) and...

gajayku (7/2/2014)

---

Hi

I m integrated the mvc application with SSIS package. I m sending the excel file from mvc application to SSIS package. I need to transform excel file data to...

Have you mapped the derived column to a destination column?

Well this is an interesting one.

I was unable to get that damned delimiter working, even though all looks fine in 'Preview' mode, as you found.

If you do a 'replace all'...

Another quick thought - what is the codepage associated with the Flat File connection manager?

I would edit the file using a decent text editor - say Notepad++ - and confirm your row delimiter (in Np++ select View/Show Symbol/Show All Characters).

Have you tried

SELECT DISTINCT ID_ITEM, DATE, ID_USER

?

Try adding a dataviewer to check that your data is as it should be.

Not without a ton of code or the purchase of a third-party add-on.

I am very surprised that this works and don't recommend it.

I have never tried, but I don't see why there would be any problem connecting to a 2012 instance from...

You're not having a good day are you? 🙂

If you are converting your input string to...