I really don't understand the issue here.

Perhaps someone else in the forum can help you.

If you have source and target columns whose data types do not match, you may need...

Just for fun, you could also try DROP/CREATE.

It's unlikely to be the reason in this case, but a server-level DDL trigger could probably make this happen.

gajayku (7/9/2014)

---

Data is not inserting in order from csv to database table. csv file has 10K records which has unique id records(1,2,3,....10000). when I transform the csv file data to...

Database tables do not have an order. What is the problem, exactly?

neltonk (7/7/2014)

---

Hi I have modified the query as directed. The filters in the query are on the columns that are part of the clustered index (primary key) so I am...

Evil Kraig F (7/3/2014)

---

I agree with Phil. You're trying to normalize data. I'd recommend, for this particular instance, to use SQL. Either with the UNION or with...

sql server developer (7/3/2014)

---

Hi All,

I'm trying to load data from multiple files into SQL server using Foreach Loop Container in SSIS 2008. All the files are in the same format...

I really wouldn't do that bit in SSIS.

Do it in T-SQL instead as a UNION. Something like this:

select participant_key

,participant_key2

,participantPosition = 1

,participant_1

,participant_rate

,participant_rate_high

,source

,date

from dbo.stage

union all

select participant_key

,participant_key2

,participantPosition = 2

,participant_2

,participant_2_rate

,participant_2_high

,source

,date

from dbo.stage

where participant_2 is not...

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...